SETRANGE --> datetime field is not empty

Pieter_Govers

Hi,

I've a question about a SETRANGE, I must have all the records from a specific table where a datetime field is not empty,

i've tried with

"Bom+ Item Tracking".SETRANGE("Pick Date", '<>%1', EmptyDate);
(EmptyDate is a global with no date assigned to)

But this don't compile.

Can somebody help me?

DenSter

try SETFILTER

SETRANGE is strongtyped, so you have to provide correctly typed values, with a 'from' and a 'to' value (both of which are optional, see F1 help).

jm

Hi Pieter,

may this helps you: http://www.mibuso.com/forum/viewtopic.php?t=13958&highlight=datetime+0dt

Pieter_Govers

To other topic solved my problem.

Thanks,

Pieter