Load data previous month based on date column

[frizqie17]

Hello,

I have a table that contain a column 'last update' which formated as a date (MM/DD/YYYY). I want to extract the data from previous month until now based on 'last update' column. How's the script should be?

Thanks.

[lotfiblo]

Hi @frizqie17 ,

You can do this:

LOAD *
from YouDatasource
Where [last update] >= MonthStart(Today(), -1);

Best,

Lotfi

[frizqie17]

Ok Thanks @lotfiblo , i'll try it