Skip to Content
0
Former Member
Jun 26, 2009 at 04:33 PM

Need help with date field using IsNull

39 Views

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