Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Convert No. in to Date or Year

Hi,

i have a field in which date is given in the no. format as 19790601

plz help me to find out how to get the date,month,year from this no.

1 Reply
Not applicable
Author

Hi,

first you have QV to tell the format: Date#(YourNoField, 'YYYYDDMM') as example.

Now you are able to build Year, ad so on:

Load *,

Year(YourDateFormat) as Year,

Day(YourDateFormat) as Day;

Load

Date(Date#(YourNoField, 'YYYYDDMM') , 'DD-MM-YYYY') as YourDateFormat,

Field2

From .......

Hope it helps.

Rainer