Skip to Content
Oct 15, 2019 at 01:00 PM

Parenthesis missing


I am trying to write a formula to hide a date range for a particular time (between 7/1 and 9/1) and it display when the current time is between 12/1 and 6/30 of the following year.

Here is what I have and I keep getting the error message "the ) is missing." I am not sure where. Can someone offer input? Is

If ({EMPLOYEE.COMPANY} = 30 and {EMPLOYEE.DATE_HIRED} in Date (2019,07,01) to (2019,09,01))
Then hide
Else show (CurrentDate in (2019,12,01) to (2020,06,30))

the formula right otherwise?