Posting date filter for up to date

monir_asian

FilteringforStart:='..'+FORMAT( StartDate);
1.ItemLedgerEntry.SETFILTER("Posting Date", FilteringforStart);

---

2.ItemLedgerEntry.SETFILTER("Posting Date", '..%1', StartDate);


I want a posting date filter up to date.


which one is best?

mohana_cse06

I prefer option 2

Chinmoy

option 2

sharad

Same here Option 2

mihail_kolev

there was a strange issue when using wildcards with SETFILTER. Have it in mind

PS: ItemLedgerEntry.SETRANGE("Posting Date,0D,StartDate);

David_Singleton

mihail_kolev wrote:

there was a strange issue when using wildcards with SETFILTER. Have it in mind

PS: ItemLedgerEntry.SETRANGE("Posting Date,0D,StartDate);

Actually I think most of those issues are now resolved BUT, I still use the setrange out of old habits. It also give you the ability to differentiate between "the beginning of time" and a "blank" date field.

DenSter

Me too, my vote goes to SETRANGE("Posting Date",0D,EndDate)