Filtering problems... HELP!

Becka

Hi all! I need to filter table by month and year(For example */06/08)... I tried different ways, but i keep searching for a perfect solution.. So if any ideas, share it then.. Thanks a Lot!

Yaroslav_Gaponov

Hi

Use DMY2DATE and DATE2DWY functions for create a first and finish dates

Becka

Yup, i did it this way.. But there`s one problem, i can`t define finish date.. `caz i don`t know on what number month ends. And i wanna work this out.. Thanks in advice

Yaroslav_Gaponov

Hi

CALCDATE('CM',somedate);

Flowfield

Hi, try this:

setfilter("posting date",'%1..%2',010608d,calcdate('+1M-1D',010608d))

Becka

Thanks a lot... Finally i got it