date conversion

[qlikapple]

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]

can any one please help

[smilingjohn]

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]

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

https://community.qlik.com/t5/Qlik-Design-Blog/Using-the-Ceil-Function-to-Create-a-Quarter-Field/ba-...

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

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/DateA...

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/DateA...

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/DateA...

Regards,
Brett