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.