Adding hours or minutes from formula to a DateTime field

[veles]

Hi.

I am using crystal XI and need some help.

I have a DateTime field that I am trying to add hours (or minutes) comming from a variable from a sub report.

The hours are calculated in a sub report and passed to the main report. In the main report I have the variable {VAR} as a number.

I need a formula that will add the hours from the number variable to the DateTime field.

I tried
dateadd('n', +20,{DateTime})

This works adding the 20 min to the DateTime field, but if I replace the +20 with +{VAR} it doesn't work.

Any help is appreciated.

Thanks

 

[veles]

It looks like the formula worked if I put it at the same level as the variable.
I am still looking into it

 

[lbass]

The formula should be in a section below the one containing the sub. So if the sub is in GH1a, you could reference the variable in a formula in GH1b, like this:

whileprintingrecords;
shared numbervar mins;
dateadd("n",mins,{table.datetime})

-LB