IIF statements (1 Viewer)

pops

New member
Local time
Today, 11:08
Joined
Jun 20, 2017
Messages
1
This is what I am trying to write:
if date 1 < date 2, (true) post in report, (false) go to next entry
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 11:08
Joined
Aug 30, 2003
Messages
36,118
Well, the IIf() would be

IIf(Date1<Date2, True, False)

but I suspect that's not all you're looking to do.
 

CJ_London

Super Moderator
Staff member
Local time
Today, 18:08
Joined
Feb 19, 2013
Messages
16,553
in vba it would be

Code:
if date1 < date2 then
     'post in report code here
Else
     'go to next entry code here
End if
 

Users who are viewing this thread

Top Bottom