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,
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
hi @pyrypeura ,
Thank you for your input.
Hello @Jsdeloria21 ,
I did not see the answer from @pyrypeura . Deleting as it is no longer needed.
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.