Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I need to convert 'YYYYMMDD' into monthname like 'Jan. , Feb. , etc....'
I manage to convert it into date using the below:
Date(alt(Date#(DATE, 'YYYYMMDD')), 'DD/MM/YYYY') as Date_Interview,
Any idea?
KR,
Hasvine
just add Month() to your exprression like this?
month(Date(alt(Date#(DATE, 'YYYYMMDD')), 'DD/MM/YYYY')) as Date_Interview_Month,
Date(alt(Date#(DATE, 'YYYYMMDD')), 'MMM') as Date_Interview,
or u want only month name ? or with date format?
Month(Date#(DATE, 'YYYYMMDD')) as Month
Hi
Try like this
Load *, Month(Date_Interview) AS Month, Year(Date_Interview) AS Year;
Load *,
Date(Date#(DATE, 'YYYYMMDD'),'DD/MM/YYYY') AS Date_Interview
YourTableName;
I want the month name.
I managed to do the date.
Many Thanks,
Hasvine
just add Month() to your exprression like this?
month(Date(alt(Date#(DATE, 'YYYYMMDD')), 'DD/MM/YYYY')) as Date_Interview_Month,
HI,
Try like this
LOAD
*,
Month(Date_Interview) AS Month_Interview;
LOAD
*,
Month(Date#(DATE, 'YYYYMMDD'), 'DD/MM/YYYY') as Date_Interview
FROM DataSource;
Hope this helps you.
Regards,
Jagan.
Thanks.
It works.
Kind Regards,
Hasvine
Some of the functions here are unnecessary I see, the same could be got using a simpler expression I shared above.
Month(Date#(DATE, 'YYYYMMDD')) as Month
It's better to be better. Isn't it?
=Date(Addmonths(today(),-1),'MMM')