G
Guest
I would like to be able to enter a year (i.e. "2004") in a form, check this
date against another date, and if the first date is less than the second,
check a check box automatically. I tried using this formula in the
expression builder but didn't work. I'm assuming it would be better to use
VB code but don't know enough about writing vitual basic:
=IIf([Deob Year]<Year([Month End Date]),[Include in Bookings
Report?]=0,[Include in Bookings Report?]=-1)
Any help would be appreciated. Thanks
date against another date, and if the first date is less than the second,
check a check box automatically. I tried using this formula in the
expression builder but didn't work. I'm assuming it would be better to use
VB code but don't know enough about writing vitual basic:
=IIf([Deob Year]<Year([Month End Date]),[Include in Bookings
Report?]=0,[Include in Bookings Report?]=-1)
Any help would be appreciated. Thanks