Thanks Cathi for the help. I tried it out and is working. Bob Archer & Craig Berntson gave me another clue to pass the parameters as date time variable or use tot() function. I tried this out as well and is working fine. With this I dont have to modify my already existing crystal reports which has no formula field.
Thanks a lot for the help
Rajeev