Solved

Date Conversion MM DD, YYYY to YYYY-MM-DD

  • 1 August 2019
  • 2 replies
  • 10 views

Badge

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.
icon

Best answer by warrendev 1 August 2019, 17:52

View original

2 replies

Badge +16

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

Badge +2

@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