This content has been marked as final.
Show 7 replies
-
Re: format
surendra j Oct 26, 2017 7:00 AM (in response to antony qvw)You can try
=Date('42736','MMM-YY')
-
Re: format
Anand Chouhan Oct 26, 2017 7:02 AM (in response to antony qvw)Try this
=Date(Num#(date))
And attached also
-
1213.qvw 146.5 K
-
-
Re: format
Andrea Gigliotti Oct 26, 2017 7:04 AM (in response to antony qvw)your date field is a string rather a number.
could you provide the file "Additional report.xlsx" ?
-
Re: format
Anand Chouhan Oct 26, 2017 7:04 AM (in response to antony qvw)For month name
=Date(Date(Num#(date)),'MMM-YY')
Or
=MonthName(Date(Num#(date)))
-
Re: format
omar bensalem Oct 26, 2017 7:04 AM (in response to antony qvw)How do you want to it to be be?
-
Re: format
omar bensalem Oct 26, 2017 7:06 AM (in response to antony qvw)Try:
MonthName(Date#(MONTH,'MMM-YYYY')) as monthName
or
MonthName(Date(Num#(MONTH))) as monthName
-
Re: format
surendra j Oct 26, 2017 7:07 AM (in response to antony qvw)may be--
Date(Datefield,'MMM-YY')
ex:
Date('42736','MMM-YY')
It will give Jan-17,Feb17...