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
Hi
Can you write your output expectation clearly?
For Month Name you just try this, use either in Script / expression
LOAD Date(MakeDate(left(Date,4),Mid(Date,5,2),Right(Date,2)),'YYYYMMDD') As Date,
Date(MakeDate(left(Date,4),Mid(Date,5,2),Right(Date,2)),'YYYYMMMDD') As DateMonthName,
Month(Date(MakeDate(left(Date,4),Mid(Date,5,2),Right(Date,2)),'YYYYMMMDD')) As MonthName
FROM
(ooxml, embedded labels, table is Sheet1);
Output will be:
Agreed, Same can be achieved by removing Date() & Alt() function from the above mentioned expression.
I thinks,she might be using Alt() functionality, then I just add month() to her expression. Else this would be working perfectly as well..
Month(Date#(DATE, 'YYYYMMDD')) as Month
Hi You can use like this as below example:
=Date(Addmonths(today(),-1),'MMM')
month(DATE COLUMN) AS DATE _iNTERVIEW