Converting [dd/mm/yyyy] String Into Date Column

Sigma Formulas and Functions

ztrean October 30, 2020, 6:26pm #1

Some of our dates come in as a string with this format [dd/mm/yyyy] is there any way to quickly convert this into a date type column?

Ryan October 30, 2020, 6:27pm #2

Hey Zachary!

You can use the DateParse Function for this! In this case, you would use the formula:
DateParse([Text Date], “[%d/%b/%Y]”)

system automatically bumped November 18, 2020, 6:35am #3

system automatically bumped December 7, 2020, 2:02pm #4

system automatically bumped December 27, 2020, 1:33am #5

system automatically bumped January 16, 2021, 5:49am #6

system automatically bumped February 5, 2021, 2:33pm #7

system automatically bumped February 27, 2021, 12:00am #8

system automatically bumped March 20, 2021, 9:57am #9

system automatically bumped April 10, 2021, 11:38pm #10

system automatically bumped May 2, 2021, 7:09pm #11