Are you doing a record selection formula? If so, just pick the field and in the condition dropdown box pick the Is Between criteria. If this isn't what you are looking for, then please post more info so we know where in the report you want this in and what its purpose is.

Hello guys,

Here is what I ended up with:



Thanks my friend,

I used your CRsyntax and converted it to Basic as follows:


Dim d As number
Dim t AS time

d= dayofweek(currentdatetime)
t= ctime(currentdatetime)


'return whether between Thursday 8pm and Sunday 8pm
IF (d = CrThursday and t >= ctime(20, 0, 0)) or d = CrFriday or d = CrSaturday or (d = CrSunday and t < ctime(8, 0, 0)) THEN
FORMULA= "Code if True"
Else
FORMULA= "Code if False"
END IF