The built-in function DATE is not supported as an argument to the PRIOR function. For example, PRIOR(DATE) is no valid. You must use PRIOR(CURRENT_DATE) instead.
The built-in function DATE is not supported as an argument to the PRIOR function. For example, PRIOR(DATE) is no valid. You must use PRIOR(CURRENT_DATE) instead.