jana
asked on
Display days passed in decimal or integer in Ms SQL 2005 script
We have a script that displays the difference between LastDate and FirstDate, but we can't get it to display a integer value, it display a Date format value.
ASKER
Where is the script going wrong?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you very Much!!!!!
ASKER
Open in new window
The problem is that the value displayed by "(LastDate-FirstDate)" is in Date Format. Example (noticed the difference column):
Open in new window