Adding Days?

[#1]

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

[martin59 · Accepted solution]

Hi,

You can do this :

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