Adding Days?

Tue, 01 Jun 2010 10:28:13 GMT

Hi,

I am sure that this will be quite a simple problem to someone, but i cant seem to find an answer so far.

I have loaded a single table, but would like to restrict the results based on a field called "Move_Out_Date"

I would like the results to only display where the "Move_Out_Date" is > 30 days from todays date.

Could anyone offer any advice on how to get this in the script?

Thanks

Dean

Re. :Adding Days?

martin59 — Tue, 01 Jun 2010 10:51:04 GMT

Hi,

You can do this :

LOAD*
FROM ....
WHERE Move_Out_Date > (today()+30);