Date-Dinamic Filter in Left-Pane Links

Hello,

in order to make easier the job of the users I’ve developed some links to store in the left-pane of each user, creating filters that give them the info needed.

But I’ve no idea how to set a work date dependent filter. I’ve already tried with CALCDATE but it didnt work to me.

I attach a sample to automate the filter and avoid each user, each day have to edit the filter.

navision://client/run?target=Form%207000001%26view=

SORTING(Field1,Field15,Field16,Field19,Field13,Field11,Field14)

%20WHERE(Field11=1**(…27/03/10)**)%26servertype=MSSQL

I suggest something like (’…’ + FORMAT(CALCDATE(’<-2M’)))

Thanks a lot.

Jorge.