Covert Day Number into Date

[lawrance]

Hi all,

I have day column and month with year but I need date.

For Example,

Day_Num	Month_Year
1	JAN-2017
2	JAN-2017
3	JAN-2017
4	JAN-207
5	JAN-2017

Expected Results:

Day_Num	Month_Year	Date
1	JAN-2017	01/01/2017
2	JAN-2017	01/02/2017
3	JAN-2017	01/03/2017
4	JAN-2017	01/04/2017
5	JAN-2017	01/05/2017

Thanks,

Lawrance A

[sunny_talwar · Accepted solution]

‌Try this

Date(Date#(Day_Num&’-‘&Month_Year, ‘D-MMM-YYYY’), ‘MM/DD/YYYY) as Date