Date Format

Hi,

I'm trying to get an output that has text and date (in mm/dd/yyyy format) in a column. I've used DateTimeFormat & DateTimeParse to format when there is date in source, but I'm not getting desired result for date, however the text output is coming in right.

Looking for experts advice!

Thank you!

Bharat S

Date Time

Accepted answers

The date syntax is case sensitive. Try making the M and D lowercase.

See more info here: DateTime Functions | Alteryx Help

All comments

The date syntax is case sensitive. Try making the M and D lowercase.

See more info here: DateTime Functions | Alteryx Help

Trying to understand.

Is it that you have a source column that has both String and Date formats in its field values?

Hi @RobertOdera

Yes, it had both values.

Thanks!

This worked, thank you!

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703