first day of each month?

[genevx]

hello all,

i'm trying to make a text box default to the first day of the current month and year. Anyone know what i have to toggle with or write? =)

genevx

 

[norm]

Not sure specifically... but check out the vba class DateTime in the object browser. It looks like there is something that might help you out like maybe the month method in combination with something else. Also maybe the DatePart function which returns something like the first day of the year given now() or date()....

good luck,
norm

 

[genevx]

found out!
it's: DateSerial(Year(Date()),Month(date()), 1)

thanks for the reply!

genevx