Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
My current date format is '06/28/2016' and the format required is '28-June,2016'
Thanks..
Hi,
try date() and date#()
date(yourdateField,'DD-MMMM,YYYY')
Regards
Hi,
try date() and date#()
date(yourdateField,'DD-MMMM,YYYY')
Regards
or if it is not in date datatype then
date(date#(dateField,'MM/DD/YYYY'),'DD-MMMM,YYYY')
Regards
Front End
=Date(Date#('06/28/2016', 'MM/DD/YYYY'),'DD-MMMM-YYYY')
Back end
Date(Date#(YourOriginalDateField, 'MM/DD/YYYY'),'DD-MMMM-YYYY') as YourNewDateField
Kindly read below blogs which will help you to understand how to handle dates in QlikView