Skip to main content

Hello, what is the easiest way to convert these dates ?

 

June 28, 2019 to 2019-06-28

 

May 31, 2019 to 2019-05-31

 

April 26, 2019 to 2019-04-26

 

etc.

@kat, you can use the DateTimeConverter to convert the date to your desired output.


@kat, you can use the DateTimeConverter to convert the date to your desired output.

Building on @warrengis answer, there are two very helpful resources for this.

  1. The Format String Flags an Examples section in the Date Time Functions documentation as it explains all of the flags and provides examples for each.
  2. The Quick Reference (a simplified version of the format string flags and examples) and Date Preview that are built into the DateTimeConverter - these will help you build date format expressions:

Reply