Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Maybe
date(Day,'DD')
But please verify if it is giving correct days output?
I'm not sure if that is correct
Try one of this
Date(DAY,'DD')
Or
Date(Date#(DAY,'DD'))