Discussion:
Datediff function in Crystal Reports
(too old to reply)
janeh
2010-03-04 20:16:02 UTC
Permalink
I am trying to create a formula in Crystal Reports 8.5 using the DateDiff
function to calculate the number of weeks between a beginning date and today.
However every time I put my information in, i get an error, telling me that
I am missing a parentheses! I can't seem to figure out what , if anything I
am doing wrong. Can anyone shed any light? I have tried to add and
subtract parens everywhere I can think of to the following formula:
DateDiff (ww, {relserv.bdate1} , CurrentDate)
Bod
2010-03-05 09:50:02 UTC
Permalink
The interval is a string variable so needs to be in quotes:
DateDiff ("ww", {relserv.bdate1} , CurrentDate)

Bod
Post by janeh
I am trying to create a formula in Crystal Reports 8.5 using the DateDiff
function to calculate the number of weeks between a beginning date and today.
However every time I put my information in, i get an error, telling me that
I am missing a parentheses! I can't seem to figure out what , if anything I
am doing wrong. Can anyone shed any light? I have tried to add and
DateDiff (ww, {relserv.bdate1} , CurrentDate)
Loading...