Post date to today

[Guest_imported]

Hello

I have a report that lists the date that a job was posted to the internet. I need to calculate the total number of days that has been open (based on today's date or when the report is run). Any suggestions?


Thanks
Matt

 

[dgillz]

Use the Datediff() function.

Datediff("d",startdate,enddate) will returnthe number of days. There are several different valid arguments you can use instead of "d". Check out the help files for full details. Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com