Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
coloful_architect
Creator II
Creator II

convert date in terms of numeric series back to date

I have a created variable; see below;

coloful_architect_0-1603462570526.png

24250 seems a October. 

but any one knows what is the date format for that?

my two questions regarding this

1. How I can convert this series number to date format

2. May I deploy a formula rather than inputting a hard code there?

Thanks 

1 Solution

Accepted Solutions
Chanty4u
MVP
MVP

you can try this way

=date(date#(DateField,'yyyymmdd'),'yyyymmdd')  

and have a look here

https://community.qlik.com/t5/New-to-QlikView/convert-integer-column-into-date/m-p/1252234

 

View solution in original post

2 Replies
Chanty4u
MVP
MVP

you can try this way

=date(date#(DateField,'yyyymmdd'),'yyyymmdd')  

and have a look here

https://community.qlik.com/t5/New-to-QlikView/convert-integer-column-into-date/m-p/1252234

 

coloful_architect
Creator II
Creator II
Author

Thanks. It turns out that 24250 is after a process of calculation. 

your formula is helpful. thanks