DateAdd

[Bentley]

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

[JoeM]

It sounds like the table that you want to apply this to isn't part of your query (or perhaps you have a typo?).

Be sure to select the table in this query, and to be sure, add the OrientationTaken field by double-clicking on it.

If it still does not, create a simple Select Query where you simply add this OrientationTaken field to it, change toe SQL View, and copy and paste your SQL code here.

[andy49]

Isn't it "yyyy"


Sent from my iPhone using Tapatalk

[JoeM]

Isn't it "yyyy"

I saw that too, but tested 'YYYY' and that also seemed to work.