Update query formula (1 Viewer)

Crazy

Registered User.
Local time
Today, 22:39
Joined
Aug 2, 2001
Messages
14
I am trying to make it so that if the value that the first part of the expression is less than 1, then a message "subscription ended" comes up, however this isnt working any suggestions as to why wud be gr8!

DateDiff("y",[Magazine Records]![Current Date],[Magazine Records]![Date Subscritpion Ends]) And IIf([days left]<1,"subscription ended","«falsepart»")
 

Fornatian

Dim Person
Local time
Today, 22:39
Joined
Sep 1, 2000
Messages
1,396
Try:

Iif([Magazine Records]![Date Subscritpion Ends]-Date())<1,"Subscription ended","«falsepart»")

Date(): Return the current date on the PC

Using "y" will give the number of years difference between the days not the number of days.

Also you have a spelling mistake in your field name: - ([Magazine Records]![Date Subscritpion Ends]

Hope that get you part way.

Ian


[This message has been edited by Fornatian (edited 08-04-2001).]
 

Users who are viewing this thread

Top Bottom