UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Does any one know how to get 01 or 02 instead of just 1 or 2? *DELETED*    
 
   
Shaz_Shaz
post Jan 1 2010, 04:48 PM
Post #1

UtterAccess Enthusiast
Posts: 65
Post deleted by Shaz_Shaz
Go to the top of the page
 
+
Shaz_Shaz
post Jan 1 2010, 04:49 PM
Post #2

UtterAccess Enthusiast
Posts: 65
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
Attached File(s)
Attached File  picture.zip ( 147.51K ) Number of downloads: 0
 
Go to the top of the page
 
+
theDBguy
post Jan 1 2010, 05:01 PM
Post #3

Access Wiki and Forums Moderator
Posts: 48,592
From: SoCal, USA
Hi,

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

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

Hope that helps...
Go to the top of the page
 
+
Shaz_Shaz
post Jan 1 2010, 07:04 PM
Post #4

UtterAccess Enthusiast
Posts: 65
Thanks mate it works!
Go to the top of the page
 
+
Shaz_Shaz
post Jan 1 2010, 07:05 PM
Post #5

UtterAccess Enthusiast
Posts: 65
Thanks Mate, it works now!
Go to the top of the page
 
+
theDBguy
post Jan 1 2010, 07:11 PM
Post #6

Access Wiki and Forums Moderator
Posts: 48,592
From: SoCal, USA
You're welcome. Glad to hear it worked! Good luck with your project.
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 18th June 2013 - 04:39 PM