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
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: