Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
i want a button that chose the last 21 days.
the feild is "date"
how i need to wrote it ?
thanks'
yarin
Hi,
use the below expresstion in Search String.
='>' & Date(Today()-21,'DD/MM/YYYY') & '<=' & Date(Today(),'DD/MM/YYYY')
PFA.
Thanks,
Mukram.
Hi,
use the below expresstion in Search String.
='>' & Date(Today()-21,'DD/MM/YYYY') & '<=' & Date(Today(),'DD/MM/YYYY')
PFA.
Thanks,
Mukram.
Just create a variable for 21days like
Click Ctrl+Alt+V
Then add v21Days as variable name. Then
= Date(Max(YourDate) - 21, 'MM/DD/YYYY')
Then use something like this.
Making sure you got your data format correctly.
LOAD *,
Date(Date#(Date, 'MM/DD/YYYY'), 'MM/DD/YYYY') AS YourDate
From ......;
Then create a button and in Action tab add Select in Field and add your fieldname as YourDate then use below expession:
= '>=' & v21Days