default Year

  • Thread starter Thread starter Steve J
  • Start date Start date
S

Steve J

Hi Is there anyway of setting the Default of a field so that if the current
month is < 8 the current year yyyy is entered, else if the current month is
7 the current year +1 is entered?
Click to expand...

Thanks
 
In the default value property of the field put
=IIf(Month(Now())<8,Year(Now()),Year(Now())+1)
 
Back
Top