Date Not Equals To 0DT

ricky76

Is there any way within a SETRANGE or SETFILTER i can specify the date is not equal to 0DT??

Thanks

zeninoleg

Hi Ricky,
What is a 0DT?
Are you trying to say 0D?
0DT is DateTime
0D is only Date

ricky76

I am trying to filter out records on the completed field, which is a datetime, where there is no datetime in the field so in effect i want SETFILTER(Completed,<> 0DT) but this syntax doesn't work. Any help would be appreciated.

zeninoleg

Try
SETFILTER(Completed, '<>%1', 0DT)
It should work

ricky76

Worked a treat. Thank you very much for your help.