DateTimeParse - ConveError

HI All, I need date in 'dd/mm/yyyy' format whereas I am getting it in 'yyyy-mm-dd' I tried 'DateTimeParse' but there is an error, can you please help Expression: datetimeparse(DateTimeNow(),"%d/%m/%y")

Error: ConvError: Formula (18): DATETIMEPARSE: Cannot convert "2020-08-17 15:49:22" to a date/time with format "%d/%m/%y": Expected separator '/%m/%y', got: '20-08-17 15:49:22'

regards, Murali

Date Time

Accepted answers

echuong1

You cannot have that format for date values. The Alteryx recognized date format is Year-Month-Day. Any variation from this would turn the values into strings.

Is there a specific reason why you want the values in a different format? If it's more for presentation purposes, you'd need to create a second field with the values formatted different. I'd advise against this, as you're essentially duplicating values. This is the same as if you'd like monetary values shown with a "$" and commas.

I'd recommend keeping all values in the proper Alteryx recognized date format for all calculations, and then converting to your formatting string presentation if needed.

RolandSchubert

Hi @Muralisagar ,

to perform calculations on dates, they have to be converted to a Date or DateTime data type using DateTimeParse - the format of a date in this data type always is "YYYY-mm-dd HH:MM:SS". After all calculations are finished, you can create the format you need using DateTimeFormat.

So the first step is to use DateTimeParse to convert the values you currently have to DateTime data type (if the data type isn't already "DateTime").

Then you can execute calcultions and convert to the format you want, but after using DateTimeFormat to create this format, you can't you the output field for calculation.

I've attached a sample workflow, hope this is helpful. Let me know if it works for you.

Best,

Roland

DateTime.yxmd

All comments

echuong1

Is the attached what you're looking for?

If your data is already a datetime, you can use the datetimeparse tool to convert it to a string with your desired format.

New Workflow1.yxmd

Muralisagar

Hi, thank you

this is good, but I want the outcome in date format for further calculations (not in the string format). please help

RolandSchubert

Hi @Muralisagar ,

So the first step is to use DateTimeParse to convert the values you currently have to DateTime data type (if the data type isn't already "DateTime").

Then you can execute calcultions and convert to the format you want, but after using DateTimeFormat to create this format, you can't you the output field for calculation.

I've attached a sample workflow, hope this is helpful. Let me know if it works for you.

Best,

Roland

DateTime.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703