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,
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.
0 -
0
-
Hello @Jsdeloria21 ,
I did not see the answer from @pyrypeura . Deleting as it is no longer needed.
Cheers!
Kind regards,
Bruno Rodriguez
0 -
You can extend the same approach to create a text field for the day of the week, along with the DAY() function.
0 -
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,
0