Date Format

[Lewe22]

How can i display the date of the the first day in the current month on a form?

Eg:

Todays Date  10/06/2008         
New Date     01/06/2008

[missinglinq]

This works on machines where the Regional Settings dispaly dates as mm/dd/yyyy. I assume it'll work for you if your Regional Settings normally display dates as you have displayed them in your example, dd/mm/yyyy.
NewDate = DateSerial(Year (Date), Month(Date), 1)

Linq ;0)>

[Lewe22]

Thanks, that has worked for the display purposes on my form!