Date Format

[dseelam]

Hello Qlik folks,

My date format is set as MM/DD/YYYY & =today() is giving me 09/10/2018

why =num(month(today())) giving me just 9, what I need is 09

Thanks,

D

[Frank_Hartmann]

num(month(today()),'00')

[Anonymous · Accepted solution]

num don't gives you preceding Zeros, just 9 as integer

using date(today(),'MM') gives you 09

[dseelam]

Thank you