Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am getting Monthyear as below ..how can I manipulate this to get the week, weekday and date also ?
Date(Date#(Trim(SubField(Header, Chr(10), 1)), 'MMM-YY'), 'MMM-YY') as MonthYear,
Thanks much.
Week(Date#(Trim(SubField(Header, Chr(10), 1)), 'MMM-YY')) as Week,
WeekDay(Date#(Trim(SubField(Header, Chr(10), 1)), 'MMM-YY')) as WeekDay,
Date(Date#(Trim(SubField(Header, Chr(10), 1)), 'MMM-YY'),'DD-MMM-YY') as Date,
Look here for more information and examples :
you can define additional parameters
D will give you day of month
WWW will give you weekday
WW will give you the weeknumber
but you Need a date in dayformat (means not a month)
e.g. =date('29.08.2016','MM/YYYY D WWW ') gives you