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: 
munnawar
Contributor II
Contributor II

How to create DAY

Hi im having DAY in date  D format ie 1,2,3,..., But i want in 'DD' ie  01,02,03 format,

Im applying logic num(DAY,'00') Format  but its not giving any output , can anyone help me out

Thanks

2 Replies
MK9885
Master II
Master II

Maybe

date(Day,'DD')

But please verify if it is giving correct days output?

I'm not sure if that is correct

its_anandrjs
Champion III
Champion III

Try one of this


Date(DAY,'DD')


Or


Date(Date#(DAY,'DD'))