Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all
here is my example and hope that you can help:
I have a field PeridoDate number form:
i.e.: I have the below field (PeriodDate)
PeriodDate:
42005
42006
42007
42008
2|Ce
40|dsad
dasf.....
..
I need to exclude everything note date how can I do it ?
Hope that you can help.
Thanks in Advance
Mario
May be like this if everything else is text
LOAD PeriodDate
FROM ...
Where IsNum(PeriodDate);
where isnum(num#(PeriodDate));
when using non numerical field as input...
or just
Where PeriodDate;
as all numerical values not qual 0 evaluate as true.
regards
Marco