Date Filter filter

shivaprasad263

Hi


Can I filter like this way

GLAccount.SETRANGE(GLAccount."No.",'1009');
GLAccount.SETRANGE("Date Filter",0D,WORKDATE-1);

Here I am filtering GLAccount no and Date Filter as '..yestarday' in GLAccount table to get the Balance. Is it works?



Thanks
Prasad

Alex_Chow

you need to do:
GLAccount.SETRANGE("Date Filter",0D,CALCDATE('-1D',WORKDATE));

David_Singleton

shivaprasad263 wrote:

Hi


Can I filter like this way

GLAccount.SETRANGE(GLAccount."No.",'1009');
GLAccount.SETRANGE("Date Filter",0D,WORKDATE-1);

Here I am filtering GLAccount no and Date Filter as '..yestarday' in GLAccount table to get the Balance. Is it works?



Thanks
Prasad

Did you try it :?: :-k

DenSter

The "Date Filter" is a flowfilter though, so that won't filter the GL Account table itself.

Alex_Chow

Umm... SETRANGE("Date Filter",0D,WORKDATE-1); works... :oops:

DenSter

Yes it works, the system uses the value to filter the target tables of flowfields, not the table itself. You don't set a filter on the Date Filter field to limit the G/L Accounts in your list.