Query: Update Field Formula

netchie

Registered User.
Local time
Today, 08:27
Joined
Aug 26, 2011
Messages
13
Hi,

I have a formula for my query:

Expr2: iif((not isnull([StartDate]) AND isnull([EndDate])) OR(not isnull([startdate]) AND [EndDate] >= date()), 1, 0)

So it says count 1 if:

StartDate: with date
EndDate: blank

OR

StartDate: with date
EndDate: today - future date

How can I update my formula to show these for Start Date instead?

It should be counted as 1 if:

Start Date: past date up to today's date
End Date: Blank

OR

Start Date: past date up to today's date
End Date: Today's date to future

Thanks in advance :)
netchie
 
Last edited:

Users who are viewing this thread

Back
Top Bottom