Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have problems with a date format.
I have this format:
date
115
216
1115
I want this:
date
2015/01
2016/02
2015/11
My problem is the month.
Thank you for you help
Try like this:
Table:
LOAD *,
Date(Date#(Num(Date, '0000'), 'MMYY'), 'YYYY/MM') as NewDate;
LOAD * Inline [
Date
115
216
1115
];
Try like this:
Table:
LOAD *,
Date(Date#(Num(Date, '0000'), 'MMYY'), 'YYYY/MM') as NewDate;
LOAD * Inline [
Date
115
216
1115
];
Hi,
Thank you very much!