Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
Date(Date#(Day_Num&’-‘&Month_Year, ‘D-MMM-YYYY’), ‘MM/DD/YYYY) as Date
Try this
Date(Date#(Day_Num&’-‘&Month_Year, ‘D-MMM-YYYY’), ‘MM/DD/YYYY) as Date