Long Date Format

[Lewkir]

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,

[edgonzales]

@Lewkir 

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.

[v-bacao-msft · Accepted 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,

[Lewkir]

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.