Date Conversion

Options
Jsdeloria21
Jsdeloria21
in Academy Discussions

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.

image.png

Any ideas is welcomed,

Thank you and Regards,

Tagged:

Answers

  • pyrypeura
    pyrypeura
    Options

    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 :

    image.png

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

    image.png
    image.png

  • Jsdeloria21
    Jsdeloria21
    Options

    hi @pyrypeura ,

    Thank you for your input.

    Regards,

  • BrunoRodriguez
    BrunoRodriguez
    edited March 2023
    Options

    Hello @Jsdeloria21 ,

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

    Cheers!

    Kind regards,

    Bruno Rodriguez

  • CQuonoey
    CQuonoey
    Options

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

  • Jsdeloria21
    Jsdeloria21
    Options

    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,

Categories