Calculating Number of days from a date to end of current month 1

[DeviousDi]

Hi,

Trying to write a query that will give me the number of days between the query date of an invoice, and the end of the current month.

I'm stuck on the last part of the query:

datediff("d", invoice.query_date, last day of month)

Is there a piece of code in Crystal XI that will do this for me? I've found nothing anywhere!

Thank you

Di

 

[IanWaterman]

You need to determine month end first

@Monthend
dateadd("m", 1, date(Year(currentdate), Month(currentdate), 01))-1

Use this formula for the last day of month in your formula

Ian

 

[DeviousDi]

Thanks, its worked a treat!

Its a handy piece of code, shall add it to my growing list!

Di