Invalid Syntax????? Expression included

[DJ_DEF_CON_1]

I have a field where I would like my Date stamp to subtract a day where the time stamp is between the following. We keep getting a Invalid Syntax error, which has us confused. It keeps referencing the second colan in the time criteria.

Does anyone have suggestions?

iif([TIME_STAMP] is Between #11:59:59# and #06:29:59#,[DATE_STAMP] -1, [DATE_STAMP])

 

[Jon K]

Delete the word IS as Is and Between are each an Operator and can't appear together.