Date Conversion

Hi Community,

Can i have help in converting date into a text formatted version date. Like1/1/2019 convert it to January 01 2019. I already have the days line item I just need to convert it to a text format date.

Any ideas is welcomed,

Thank you and Regards,

Tagged:

Answers

  • Hi,

    To accomplish this you will need a month list that you can use to get full name of month items. Below is example of month list :

    When you have month list created getting date to text is quite simple. Below are formulas and end result of module calculating this presented.

  • hi @pyrypeura ,

    Thank you for your input.

    Regards,

  • BrunoRodriguez
    edited March 2023

    Hello @Jsdeloria21 ,

    I did not see the answer from @pyrypeura . Deleting as it is no longer needed.

    Cheers!

    Kind regards,

    Bruno Rodriguez

  • You can extend the same approach to create a text field for the day of the week, along with the DAY() function.

  • Hi @CQuonoey ,

    I founf my mistake the format for the Month Name should be List formatted not MOnth Period. I am testing it now.

    Appreciate your time looking into it.

    Thanks,