Date Format

[SomuGS]

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

[Luke_C · Accepted solution]

Hi @SomuGS 

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

See more info here: DateTime Functions | Alteryx Help

[RobertOdera]

Hi, @SomuGS 

Trying to understand.

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

[SomuGS]

Hi @RobertOdera 

Yes, it had both values.

Thanks!

[SomuGS]

Hi @Luke_C 

This worked, thank you!

[RobertOdera]

Okay, got it.

Use ToString([Your Date Field]) to force all values to String and then make the updates @Luke_C  mentioned.

[SomuGS]

Hi @RobertOdera 

Thanks for the suggestion, will try it as well.

Thanks,

Bharat S

[RobertOdera]

You're most welcome @SomuGS