Access 2002 SP3 -- Calculated Field Using Current Date

[ZAK]

I want to create a calculated field in my database. The current field is as
follows:

Days Since Test: [Date Completed]-[Date Test Conducted]

But, I want to substitute the [Date Completed] field with the current date
so that I can track how "old" an assignment is. How do I modify my
expression to use the current date?

 

[pietlinden]

I want to create a calculated field in my database.  The current field is as
follows:

Days Since Test: [Date Completed]-[Date Test Conducted]

But, I want to substitute the [Date Completed] field with the current date
so that I can track how "old" an assignment is.  How do I modify my
expression to use the current date?

Days Since Test: Date()-[Date Test Conducted]

 

[ZAK]

When I paste your modified expression into my database and run the query, I
get the error: "undefined function 'Date' in expression". Any further
suggestions?

I want to create a calculated field in my database. The current field is as
follows:

Days Since Test: [Date Completed]-[Date Test Conducted]

But, I want to substitute the [Date Completed] field with the current date
so that I can track how "old" an assignment is. How do I modify my
expression to use the current date?

Days Since Test: Date()-[Date Test Conducted]

 

[ZAK]

Problem solved by another query response in this forum : Date function not
recognized on 02/24/2008

When I paste your modified expression into my database and run the query, I
get the error: "undefined function 'Date' in expression". Any further
suggestions?

I want to create a calculated field in my database. The current field is as
follows:

Days Since Test: [Date Completed]-[Date Test Conducted]

But, I want to substitute the [Date Completed] field with the current date
so that I can track how "old" an assignment is. How do I modify my
expression to use the current date?

Days Since Test: Date()-[Date Test Conducted]