Day number in month

[philippr1991]

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!

[shiveshsingh · Accepted solution]

=Day(Date)

This will work. You can also try a master calendar

[raman_rastogi · Accepted solution]

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