Date Formula

[Aurora]

I am using Access 2000

I have a query with a formula that basicly says -
DateSSigned: IIf([IASupv-Sign] Is Null," ",Date())
(When the supervisor signs [IASupv-Sign] the date field
[DateSSigned] is automatically filled in with today's
date. The formula works good except that I have found
that the date changes every time we open the record. I
want to keep the original date the supervisor signed the
field. I think I have to use something different
then "Date()" but do not know what to use. Can you help
me.

Aurora

 

[JL]

If I understand you correctly, all you have to do is to replace the Date() to
display the date with [IASupv-Sign].

The correct syntax would be,

DateSSigned: IIf(IsNull([IASupv-Sign]),"",Format([IASupv-Sign], "MM/DD/YYYY"))

Hope this helps.

 

[Aurora]

I do not think you understood my question. When the
Supervisor completes the field [IASupv-Sign] that is his
signature that everthing has been completed. When he does
this I want the field [DateSSigned] to automatically enter
the current date and to keep that date and not allow it to
change everytime you open the record.

Is that any clearer? The "Date()" function enter today's
date but also changes everytime you open the record. I do
not want it to change. That is why I think I am using the
wrong date function and need help to find the right one.

Aurora

-----Original Message-----
If I understand you correctly, all you have to do is to replace the Date() to
display the date with [IASupv-Sign].

The correct syntax would be,

DateSSigned: IIf(IsNull([IASupv-Sign]),"",Format([IASupv- Sign], "MM/DD/YYYY"))

Hope this helps.

I am using Access 2000

I have a query with a formula that basicly says -
DateSSigned: IIf([IASupv-Sign] Is Null," ",Date())
(When the supervisor signs [IASupv-Sign] the date field
[DateSSigned] is automatically filled in with today's
date. The formula works good except that I have found
that the date changes every time we open the record. I
want to keep the original date the supervisor signed the
field. I think I have to use something different
then "Date()" but do not know what to use. Can you help
me.

Aurora

.

 

[JO]

Hi Aurora,
I built and ran your query. Without knowing much about what you want
overall, I thought my approach would be to make a table with the IASupv-Sign
field and a Date/time field called SupDate. I then made the query dependent
on the table, where I could enter the date and have it held for future use.

SELECT IIf([IASupv-Sign] Is Null," ",[SupDate]) AS DateSSigned,
tDate.SupDate
FROM tDate;

Hope this helps! Let me know if, or of not, and maybe I can get there.

I do not think you understood my question. When the
Supervisor completes the field [IASupv-Sign] that is his
signature that everthing has been completed. When he does
this I want the field [DateSSigned] to automatically enter
the current date and to keep that date and not allow it to
change everytime you open the record.

Is that any clearer? The "Date()" function enter today's
date but also changes everytime you open the record. I do
not want it to change. That is why I think I am using the
wrong date function and need help to find the right one.

Aurora

-----Original Message-----
If I understand you correctly, all you have to do is to replace the Date() to
display the date with [IASupv-Sign].

The correct syntax would be,

DateSSigned: IIf(IsNull([IASupv-Sign]),"",Format([IASupv- Sign], "MM/DD/YYYY"))

Hope this helps.

I am using Access 2000

I have a query with a formula that basicly says -
DateSSigned: IIf([IASupv-Sign] Is Null," ",Date())
(When the supervisor signs [IASupv-Sign] the date field
[DateSSigned] is automatically filled in with today's
date. The formula works good except that I have found
that the date changes every time we open the record. I
want to keep the original date the supervisor signed the
field. I think I have to use something different
then "Date()" but do not know what to use. Can you help
me.

Aurora

.