how to filter posting date by year?

julkifli33

hi all
i create variable year (text)
how to filter posting date by that variable ?

FORMAT("Posting Date",0,'<Day,2>/<Month,2>/<Year4>'),Year);

--> failed
can anyone tell me what's wrong with my code?
thanks

kine

What about this:

  SETRANGE("Posting Date",DMY2DATE(1,1,Year),DMY2DATE(31,12,Year));

8)

julkifli33

hi
thanks a lot kine
but how about if i want to use end of month
like for example if i want to use february

SETRANGE("Posting Date",DMY2DATE(1,Month,Year),DMY2DATE(31,Month,Year));
how to indicate that not 31
but end of month

julkifli33

no need
solved already
thanks a lot

kine

o not forget about possibility to use CALCDATE('<-CM>',MyDate) and CALCDATE('<CM>',MyDate) to find beginning and end of month, same for <-CY> and <CY> for beginning and end of year.

julkifli33

kine wrote:

o not forget about possibility to use CALCDATE('<-CM>',MyDate) and CALCDATE('<CM>',MyDate) to find beginning and end of month, same for <-CY> and <CY> for beginning and end of year.

noted kine , thanks
but i'm using this code is enough

SETRANGE("Posting Date",DMY2DATE(1,Month,Year),DMY2DATE(1,Month+1,Year)-1);

kine

It is not enough, it will not work for last month in the year...