topic Re: Need a help in date formatt in QlikView

Need a help in date formatt

SatyaPaleti — Mon, 04 Jan 2016 17:26:52 GMT

Hi Friend,

I am having date in following format '01-DEC-2015' but i want to show this in 12/01/2015

what is the function i need to use here

Thank you,

Satya Paleti

sunny_talwar — Mon, 04 Jan 2016 17:29:10 GMT

Try this:

Date(Date#('01-DEC-2015', 'DD-MMM-YYYY'), 'MM/DD/YYYY')

Replace 01-DEC-2015 with your field name to do this in the script

Date(Date#(DateField, 'DD-MMM-YYYY'), 'MM/DD/YYYY') as DateField

SatyaPaleti — Mon, 04 Jan 2016 17:41:05 GMT

Thank you so much Sunny It Works