Sigma Community

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

system automatically bumped May 24, 2021, 2:55pm #12

system automatically bumped June 16, 2021, 6:53am #13

system automatically bumped July 9, 2021, 2:58am #14

system automatically bumped July 31, 2021, 3:05pm #15

system automatically bumped August 23, 2021, 4:18pm #16

system automatically bumped September 16, 2021, 4:11am #17

system automatically bumped October 9, 2021, 7:44pm #18

system automatically bumped November 2, 2021, 10:04pm #19

system automatically bumped November 27, 2021, 1:25am #20