Created date columns

Brian B

Created date columns. They converted to alphanumeric. When I try to perform a compare date/time of the two newly created columns, the error is "Not a date". Can the new columns be converted to 'date' datatype?

Henry Simms

Hi @Brian B

Data Studio recognises a range of date and time formats that can be parsed to "Date" type on load, depending on the parsing option selected.

If your date format if not recognised automatically, you can use the Create Date/timestamp function to create your Date type. This will probably involve some text manipulation like substringing, so I would recommend trying out the Parse Date function that's already been created by @Danny Roden and can be downloaded from the Functions Library.

Out of interest, what format are your dates in?

Henry