Date Calculation

SiriKoganti

Hi All,

I am trying to calculate previous date based on the filters appliyed on the request form.
I am using Calcdate and Getfilters when I execute iam getting syntax problems.

Can any one please help me on this.

Thanks,

mohana_cse06

Can you show us the code..

SiriKoganti

FilterDate := FORMAT("Item Ledger Entry".GETFILTER("Item Ledger Entry"."Posting Date");)
"Item Ledger Entry".SETRANGE(FilterDate,CALCDATE('-1D',FilterDate),FilterDate);

mohana_cse06

What is your requirement..

If i understood your requirement correctly and if you want to get the Previous date within your posting date filter range then try the below code

IF GETRANGEMIN("Posting Date") <> 0D THEN
  SETRANGE("Posting Date",CALCDATE('-1D',GETRANGEMIN("Posting Date")),GETRANGEMAX("Posting Date"));
Message("Item Ledger Entry".GETFILTER("Item Ledger Entry"."Posting Date"));

kine

And please, each time you are using the date formula, use it correctly:

'<-1D>'

else your code will not be multilanguage enabled...