Date field showing null when used select records

[ishwarappa]

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

[DavidP · Accepted solution]

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:

[ishwarappa]

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

[ishwarappa]

[ishwarappa]

Somehow I am able to resolve this issue on my own. Thank you again for great support.

Keep it up the good work.

Regards

Ishwarappa