I have a field that represents a date in the format 20160401
I need to
1. Change the field so that it is recognised as a date
2. Only include the records where the date is greater than today
May be do like this:
Where DateField > Today();
LOAD Date#(DateField, 'YYYYMMDD') as DateField
Some blogs on how to read date correctly:
Why don’t my dates work?
Get the Dates Right
And to avoid the preceding load and to filter the records already at the source:
Let vCutOff = Num(Date(Today(),'YYYYMMDD'));
WHERE DateField > $(vCutOff);
Retrieving data ...