Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
philippr1991
Contributor II
Contributor II

Day number in month

Hi everyone,

im new to Qlik and couldnt find a solution in the Forum to my Problem yet.

I would like to see the number of the Day in a month

For example: 03.04.2018 is shown as 3 (european timestamp)

Im currently using the DayNumberofQuarter function

but what i want is basicly a DayNumberofMonth function which doesnt seem to exist.

Im glad for any help. 

Im using the autocalendar btw. in case i Need a mastercalendar please let me know!

2 Solutions

Accepted Solutions
shiveshsingh
Master
Master

=Day(Date)

 

This will work. You can also try a master calendar

View solution in original post

raman_rastogi
Partner - Creator III
Partner - Creator III

Hi Phillippr

Try Day () function

 refer qlik help for more functions details.

https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTim...

 

Regards

Raman

View solution in original post

2 Replies
shiveshsingh
Master
Master

=Day(Date)

 

This will work. You can also try a master calendar

raman_rastogi
Partner - Creator III
Partner - Creator III

Hi Phillippr

Try Day () function

 refer qlik help for more functions details.

https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTim...

 

Regards

Raman