converting following syntax to crystal report
Your formula would look something like:
IF {tblChild.dob} in [date(xx,xx,xxx) to date(xx,xx,xxxx)] THEN 'I'
else . . .
<< Subject: converting following syntax to crystal report
Date: Thu, May 22, 2003 1:18 PM
I am trying to put this column into crystal report, however I am
having trouble getting down the cyrstla report syntax.
This query is use with MSFT access sql.
IIf([tblChild].[DOB]
Between #5/8/2000# And #5/8/2003#,"I",
IIf([tblChild].[DOB] Between #5/8/1998# And #5/8/2000#,"P",
IIf([tblChild].[DOB] Between #5/8/1990# And #5/8/1998#,"S",
IIf([tblChild].[DOB] Between #5/8/1900# And
#5/8/1990#,"Xpired","xxx"))))
AS [Age Group]
Thanks a million
>>
