Datediff query question

[joolsUK0575]

Hi there

I'm working on a query where I need to calculate the number of days left before a deadline.

There is a slight twist though. I have created a query which has an expression field in it as follows: OfficerDeadline: DateAdd("ww",5,[Date_Valid]) I need to do the calculation off of this field.

There is a field in the database called Deadline BUT the dates in this vary between a 5 week date and an 8 week date which is why I created the OfficerDeadline expression to add on 5 weeks to the Date_Valid field.

So, any ideas as to how I get it to work?

Thanks for any help

Jools

 

[Mile-O]

I don't know you decide on deadline periods so put a field with the deadline period in the relevant table and use that in the query's DateDiff()

ie.

DateAdd("ww",[DeadlinePeriod],[Date_Valid])

 

[joolsUK0575]

Ah, I can't do that

If it was a database that I had built myself then easy, but it is a corporate database that is not allowed to have the structure changed.

Any ideas?