Post deleted by Shaz_Shaz

Hi everybody,

I am using Day(Now) to get current day and it returns a single number of day e.g. 1,2,3,4….
Does any one know how to get 01 or 02 instead of just 1 or 2?
Day(Now) = 1
I need to see Day(Now) = 01

Please suggest me any if there is any parameter of function which could help me.

Thank You

Hi,

If you don't care that "01" is a string, you could try something like:

Format(Day(Date()), "00")

Hope that helps...

Thanks mate it works!

Thanks Mate, it works now!

You're welcome. Glad to hear it worked! Good luck with your project.