Custom date format that will match "1st July 2010"

More

12 years 7 months ago #1809 by Marc

Custom date format that will match "1st July 2010" was created by Marc

Hello

How do I write a custom date format that will match "1st July 2010" or "23rd July 2010" etc.? Or is this not possible?

Regards,
Marc

Please Log in or Create an account to join the conversation.

More

12 years 7 months ago #1810 by admin

Replied by admin on topic Re: Custom date format that will match "1st July 2010"

Marc

All you need to do is get rid of 'st nd' etc using replace function than apply d mmmm yyyy format 1st July 2010"

Peter

Mike
ETL Architect

Attachments:

Please Log in or Create an account to join the conversation.