Thank you for kind support always. Following date field value becoming null when I used SELECT tool. May I know how to solve this? Estimated Revenue Dt FMEstimated Revenue Dt FQOrder Init Dt FQ18-Aug18-Q317-Q4 Sample input.csv Date column value becoming NULL after select.yxmd

Date field showing null when used select records

Thank you for kind support always.

Following date field value becoming null when I used SELECT tool. May I know how to solve this?

Estimated Revenue Dt FM	Estimated Revenue Dt FQ	Order Init Dt FQ
18-Aug	18-Q3	17-Q4

Sample input.csv

Date column value becoming NULL after select.yxmd

Date Time

Accepted answers

DavidP

18-Aug is not a recognized Alteryx date format, so you have to use a DateTimeParse function first to convert it to a date format before changing the data type to DateTime, like this:

dateformat.yxmd

All comments

DavidP

18-Aug is not a recognized Alteryx date format, so you have to use a DateTimeParse function first to convert it to a date format before changing the data type to DateTime, like this:

dateformat.yxmd

ishwarappa

Thank you very much for the solution. It really helped. May I know how to convert 2018-08-01 to 201808?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703