date query

stevie1969

Registered User.
Local time
Today, 09:54
Joined
Mar 10, 2006
Messages
22
I have a text box that has todays date displayed. How can I get it to display the first day of the month i.e. instead of the 16/12/2006 it shows 01/12/2006



thanks
 
Maybe subtract the number of the day from the date plus one...
Code:
=Date() - Day(Date()) + 1
Plug that into the ControlSource property
 

Users who are viewing this thread

Back
Top Bottom