I am trying to use the following formula to extract data however, I am receiving the following error on my date field "a number, currency amount, boolean, date, time, date-time, or string is expected here". The qeury is:
{PDRACCMAS_RECORD.CH_PNO_KEY} > 1 AND
{PDRACCMAS_RECORD.CH_HOSP_ID_CODE} = 1 AND
{PDRACCMAS_RECORD.CH_FYR} = 2009 AND
<> ISNULL ({PDRACCMAS_RECORD.CH_ORIGINAL_BILL_DT})
CH_ORIGINAL_BILL_DT DISPLAYS AS HH/DD/CCYY HH:MM:SS FORMAT.
Thanks
Edited by: Jack Hubbard on Jun 26, 2009 6:33 PM