topic Re: date conversion in QlikView

date conversion

qlikapple — Sat, 16 Nov 2024 01:51:59 GMT

HI all ,

I have date fields like below

01-NOV-19

02-NOV-19

16-NOV-19

I need custom fields like year, month , day, quarter with out using master calender,, can anyone please help

qlikapple — Mon, 25 Nov 2019 05:05:11 GMT

can any one please help

smilingjohn — Mon, 25 Nov 2019 05:07:52 GMT

Hey,

Make sure in the script this is in a date format ,

Then you can use in the below script to get the output

Year(Date) as Year

Month(Date)as Month and so on ....

Brett_Bleess — Mon, 09 Dec 2019 17:02:42 GMT

I suspect you were still trying to figure out Quarter, here is a Design Blog post on that:

Here is Help link on the others mentioned in the other post just in case:

Regards,
Brett