M momoko Registered User. Local time Today, 19:39 Joined Oct 7, 2001 Messages 41 Jan 4, 2006 #1 Hi, How can I get a 2 digit month when I use month(now())? I've getting only 1 instead of 01. Please advise.
Hi, How can I get a 2 digit month when I use month(now())? I've getting only 1 instead of 01. Please advise.
allan57 Allan Local time Today, 19:39 Joined Nov 29, 2004 Messages 336 Jan 4, 2006 #2 use the format command:- format(month(now()), "00") or format(now(), "mm")