View Full Version : dates in query


FedericoQuatro
03-21-2002, 07:23 AM
the field in my query needs to change every
year
01/01/(year(now())-1)
but it seems i can't concatenate in my query
someone please help me...

Dreamboat
03-21-2002, 05:39 PM
It's something like:

=(day[date],month[date],year(today)-1)