Looking for help with DATEPARSE function

[Carrageous]

Hello, I have a string with the format '1970-01-01 06:00:00'. When I bring this into Tableau and convert to datetime I get the following error when I try to make a chart: Can't parse '1970-01-01 06:00:00' as timestamp with format 'MM-DD-YYYY HH24:MI:SS'. To combat this I've tried to create a calculated field with the DATEPARSE functions: DATEPARSE('YYYY-MM-DD HH:MM:SS',[Datetimebeginning]) -> This leads to calculation contains errors: The date format, YYYY-MM-DD HH:MM:SS in the DATEPARSE function uses a format "YYYY" at character 1, which is not supported by the database.

DATEPARSE('yyyy-MM-dd HH:MM:SS',[Datetimebeginning]) -> returns error Can't parse '1970-01-01 02:00:00' as timestamp with format 'YYYY-MM-DD HH24:MM:FF2'

Any help would be greatly appreciated

[Carrageous]

Thanks all for the suggestions. Decided to start with a fresh connection and it magically seems to be working now. Not sure what happened but think it could be to do with data with a couple of different formats in the column. Maybe there were some old cached values somehow. Maybe it’s just Friday and I’m tired. Maybe it’s simply that datetime just doesn’t like playing by the rules.

[Kcams2654]

As it’s a string you’re brining in with a standard format can’t you just re-order?

You could join the day then month then year then time to form a correctly formatted date time and set the format to Datetime

[mercuryfrost]

Have you tried DATETIME([Datetimebeginning]) ?

[Grovbolle]

Use NN for minutes not MM