Hello,
I am trying to use the date add to calculate the expiry date of orientations. I have a field labeled 'OrientationTaken' and another 'OrientationEpry'. I am trying to create the expression in the query that looks like this DateAdd('YYYY',3,[orientationtaken]). however I get a parameter box to enter the date when I run the query. I also have to type the field in as it isn't being recognized when building the expression (hope that makes sense). Any ideas as to what I am doing wrong?
Thanks,
Ben