Date Format

  • Thread starter Thread starter Aurora
  • Start date Start date
A

Aurora

I am using Access 2000

In a query, I have the following formula
DateSSigned: IIf([IASupv-Sign] Is Null," ",Date())

to insert the current date when a signature is put in to
the IASupv-Sign field. But this date is changing each
time we bring up the record, I believe because " Date()"
brings up the current (today's) date. What should I be
using to bring up the current date when the appropriate
field is signed but keep that date in the field without
changing?

Please help!
Aurora
 
You'd need to test if there already is a date in the field, and use that
field instead of Date() function. Something like this, perhaps:

DateSSigned: IIf([IASupv-Sign] Is Null," ",IIf([DateSignedField] Is
Null, Date(), [DateSignedField]))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Formula 3
Date function 5
The query cannot be completed. 1
Max & Min Dates 0
date format 6
#error - Blank 3
Excel Message box with days of month & date. 1
Display query results only if field is not null 3

Back
Top