DateDiff
I have read in this forum that there is some difficulty with DateDiff.
I'm getting this in my reports: 319.11:37:25.9687500
I believe the answer to be correct, but I would rather just have the integer, or 319 in this case.
I can't seem to find any formatting options to show only the 319.
The formula in the textbox is: [DateDiff([Date],[PackageList1.PackageDateIn])]
Anyone have a solution?
Dan
I'm getting this in my reports: 319.11:37:25.9687500
I believe the answer to be correct, but I would rather just have the integer, or 319 in this case.
I can't seem to find any formatting options to show only the 319.
The formula in the textbox is: [DateDiff([Date],[PackageList1.PackageDateIn])]
Anyone have a solution?
Dan
Comments
DateDiff function returns TimeSpan value:
http://fast-report.com/documentation/UserM...uncdatediff.htm
Write the following to display the number of days:
[DateDiff([Date],[PackageList1.PackageDateIn]).Days]
Thanks for your help.