Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi @frizqie17 ,
You can do this:
LOAD *
from YouDatasource
Where [last update] >= MonthStart(Today(), -1);
Best,
Lotfi
Ok Thanks @lotfiblo , i'll try it