year to date formula 2

[moonknightt]

I need help on a formula that takes a date parameter and gives me the year to date.

For example: if the user chooses a march date, it will display results from january to march

Thanks

 

[dgillz]

Try:

{DateField} in date(2003,1,1) to {?EndDate}



Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[synapsevampire]

Try:

To just display it, use:

totext(cdate(year({?EndDate}),1,1))+" to "+totext({?EndDate})

To use it in a record selection formula, use:

{table.DateField} >= cdate(year({?EndDate}),1,1) and
{table.DateField} <= {?EndDate}

This doesn't hardcode the first date as in dgillz's example, so it will work next year too.

Note that if you have a datetime field, you'll want to verify that both dates are being passed to the database (Database->Show SQL Query).

-k