7 days ago up today macro

[#1]

hi everyone

i have button named weekly,

i want when i press this button , my chart shows related data from 7 days ago to today ,

i want macro for this,

best regards

hamide

[MarcoWedel]

Try with a field search action and a search expression for the last 7 days.

Hope this helps

Regards

Marco

[#3]

how can i do  this ?

[MarcoWedel]

Hi,

there are lots of similar threads, try using the search function of this community.

one result:

"last 7 days" filter

hope this helps

regards

Marco

[petter]

It is a bit convoluted but it could look like this:

[#6]

unfortunately my date is shamsi date , that is not the system date

my format is 1394/07/04

i don't know how solve it?

[MarcoWedel]

maybe helpful:

Re: Re: How can sort special format date in search object's results?

regards

Marco

[petter]

Actually - if your Load Script's environment variables are in place - which they are by default - there shouldn't be a problem of you using a different date format. The screenshot only shows the dates in US date-format. But yours should show it in shamsi date. The formula/expression shouldn't be affected by this. That is why the Date()-function has been used by not specifying explictly the date format so it will use the format you have on your Windows computer or what is set in the beginning of your load script.