got a Date field YYYYMM in a table, formatted like this in an earlier step/app:
Date(Date#(MyField,'YYYYMM'),'YYYYMM') AS Period
Now, in a second app, I will load this table (with the Period field), and use a where clause that should only load records where Period is less than todays YYYYMM. For example, now we have March 2015 (201503) and then I will only load records less than 201503.
How can I do that? Format and use today() somehow?