Calculating Dates:

[Peter]

Hi all, I have this issue with calculating dates..

In the Open Form event I want to create a message:
If the value between Today () and the date in the control [Expire] equals or
is less than 90 days?

Thanks!

 

[RonaldoOneNil]

If datediff("d",date(),[Expire]) <=90 then
Msgbox "Due to expire message . . "
End If

 

[Peter]

Thanks a lot Ronaldo!

If datediff("d",date(),[Expire]) <=90 then
Msgbox "Due to expire message . . "
End If

Hi all, I have this issue with calculating dates..

In the Open Form event I want to create a message:
If the value between Today () and the date in the control [Expire] equals or
is less than 90 days?

Thanks!

 

[Peter]

... i tried this in Access 2007..but..seems the date() does not function

If datediff("d",date(),[Expire]) <=90 then,,,

???

If datediff("d",date(),[Expire]) <=90 then
Msgbox "Due to expire message . . "
End If

Hi all, I have this issue with calculating dates..

In the Open Form event I want to create a message:
If the value between Today () and the date in the control [Expire] equals or
is less than 90 days?

Thanks!

 

[Bob Quintal]

.. i tried this in Access 2007..but..seems the date() does not
function

If datediff("d",date(),[Expire]) <=90 then,,,

???

The Form_Open event is too early in the process for the code to work,
try moving it to the Form_Current event.

You may also have a references issue with the date() function, Google
for that, and/or try the now() function which is date() plus time()

Q

If datediff("d",date(),[Expire]) <=90 then
Msgbox "Due to expire message . . "
End If

Hi all, I have this issue with calculating dates..

In the Open Form event I want to create a message:
If the value between Today () and the date in the control
[Expire] equals or is less than 90 days?

Thanks!

 

[Peter]

Thanks Bob..will try that one..

.. i tried this in Access 2007..but..seems the date() does not
function

If datediff("d",date(),[Expire]) <=90 then,,,

???

The Form_Open event is too early in the process for the code to work,
try moving it to the Form_Current event.

You may also have a references issue with the date() function, Google
for that, and/or try the now() function which is date() plus time()

Q

If datediff("d",date(),[Expire]) <=90 then
Msgbox "Due to expire message . . "
End If

:

Hi all, I have this issue with calculating dates..

In the Open Form event I want to create a message:
If the value between Today () and the date in the control
[Expire] equals or is less than 90 days?

Thanks!

--
Bob Quintal

PA is y I've altered my email address.
.