Hello,
I have problem with datediff function. When I try to calculate number of years between two dates (and use yyyy interval) something goes wrong. No matter if I insert yyyy into pair of quotes or write it without quotes, access adds two quotes before and two after interval.
for example:
instead of datediff("yyyy",dateOfBirth,now())
i have datediff("""yyy""",dateOfBirth,now()).
I don't know what's going on with this... Any help suggestions will be appreciated.
Greets from Lodz, Poland.
Lucas