how to get start of the year and end of the year?

julkifli33

hi all...
i want to do filtering
for example 27/06/11 --> so it means filtering become 01/01/11..31/12/11
if 01/01/10 --> so it means 01/01/10..31/12/10
as long as i remember to get the first month is CM, is it?
can we use CY? and how about end of year?

einsTeIn.NET

Beginning of the year:

CALCDATE('<-CY>',YourDate);

End of the year:

CALCDATE('<CY>',YourDate);

And please, try to use the search next time. Thx.

kriki

Or also:

datStartOfYear := DMY2DATE(1,1,DATE2DMY(datYourDate,3));
datEndOfYear := DMY2DATE(31,12,DATE2DMY(datYourDate,3));

julkifli33

kriki wrote:

Or also:

datStartOfYear := DMY2DATE(1,1,DATE2DMY(datYourDate,3));
datEndOfYear := DMY2DATE(31,12,DATE2DMY(datYourDate,3));

thanks a lot