Month to date and year to date problem.

[tmunson99]

I am trying to create a report that will calculate month to date and year to date. I need to be able to compute both for a given date. For example if the user indicates that the date is 10/11/2004, that is the date I want to compute month to date and year to date on for a set of currency values.

 

[kskid]

Try the following.

Assume that ?dateparm is a date parameter entered by the user.

//@YTD
{table.date} in date(year({?dateparm}),1,1) to {?dateparm}

//@MTD
{table.date} in date(year({?dateparm}),month({?dateparm}},1) to {?dateparm}

-LW