Quick quesiton which I'd have thought wouldn't be that hard but has stumped me so far.
How do I format a date so it appears like: "1st Janurary 2019"?
Thanks,
Solved! Go to Solution.
Hi @Lewkir ,
Please try this format:
d MMMM yyyy
It seems that the date of the format "1st" is more complicated, and the use of numbers seems to basically meet your needs.
utcNow('d MMMM yyyy')
formatDateTime('2019-07-01','d MMMM yyyy')
Best Regards,
Hi there! I think it's the ordinal indicator ('st') that's complicating things. I don't think it's part of the standard, but it doesn't mean it's impossible. Essentially, you'd want to break the date number off, look at the last digit and build a switch:
If the last digit is a 1, then set the indicator to 'st'
If the last digit is a 2, then set it to 'nd'
If it's 3, then set it to 'rd'
otherwise, set it to 'th'
And then piece together the date as a concatenated string to present wherever you'd like.
We can do all of this without code, or there's probably a way to do it with an expression or two. What's your comfort level like? Keep us posted.
-Ed-
If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.
Hi @Lewkir ,
Please try this format:
d MMMM yyyy
It seems that the date of the format "1st" is more complicated, and the use of numbers seems to basically meet your needs.
utcNow('d MMMM yyyy')
formatDateTime('2019-07-01','d MMMM yyyy')
Best Regards,
Cheers, after re-reading the email I've realised I only needed the format 1 January 2019 so this will suffice.
Thanks for your help.