I have this this setup in crystal
if isnumeric(mid({ServiceInfo.SvcFrequency},2)) then
{ServiceHistory.ServiceDate} + 7 * val(mid({ServiceInfo.SvcFrequency},2))
else
0
My problem is I want to specify a stop date. Now is there a way to look at that formula and repeat it over and over to a specified end date?
Such as
So if the last service date was 1/1/07 and the freqency is w001(every 1 weeks) then the next service dates would be
1/08/07
1/15/07
1/22/07
...
...
Specified end date
And it would display every date that the service occurs on the report?
Thanks.Anyone? Please
Wednesday, March 21, 2012
How to loop this
Labels:
crystal,
database,
isnumeric,
loop,
microsoft,
mid,
mysql,
oracle,
server,
servicedate,
serviceinfo,
setup,
sql,
svcfrequency,
thenservicehistory
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment