J
James Pelletier
I have five queries in my database which need to calculate the number of
days between today's date and the target finish date. I use this format:
DaysLeft: DateValue("12/31/2009")-Date()
I want to declare a constant, for example:
Define FINISHDATE 40178
and then:
DaysLeft: FINISHDATE-Date()
so I only have to change the value in one place if the target date changes.
Does anyone have any ideas on how to achieve this?
Jim
days between today's date and the target finish date. I use this format:
DaysLeft: DateValue("12/31/2009")-Date()
I want to declare a constant, for example:
Define FINISHDATE 40178
and then:
DaysLeft: FINISHDATE-Date()
so I only have to change the value in one place if the target date changes.
Does anyone have any ideas on how to achieve this?
Jim