set a date field to 1st january of this year

[sdel_nevo]

Hi All



I am stuck on this problem

i have a form with to date fields startdate and enddate

i would like to have the startdate field always set to 1st January of the current year but can't seam to get my head round the code

any help would be awesome

Steve

[RuralGuy]

Have you looked at the DateSerial function?

[sdel_nevo]

Hi Rural Guy

i think i have it now

this formatting is working in a text box

="1/1/" & Year(Date())

many thanks

Steve

[RuralGuy]

I don't think that will create a DateTime value where the DateSerial function with similar parameters will.

[sdel_nevo]

Hi RuralGuy

your right after playing around with it i used this

=DateSerial(Year(Date()),1,1)

this is what i was after

many thanks for the input

Steve

[RuralGuy]

Excellent! Glad we could help. You learn quickly!