Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
num don't gives you preceding Zeros, just 9 as integer
using date(today(),'MM') gives you 09
num(month(today()),'00')
num don't gives you preceding Zeros, just 9 as integer
using date(today(),'MM') gives you 09
Thank you