I am one step away from a Crystal Automation project being completed. This problem is driving me crazy, so I hope you guys can help me. I have a Date field and a formula that calculates time. I have combined these two fields into one formula that I use as a datetime stamp: the formula is called @DateCombine, and it has this simple formula:
*********************************************************
DateTimevar timeStamp;
timeStamp:=DateTime({TWDATA.LastChangeDate},{@convertNum})
***********************************************************
So in my report I have a date time field that reads like a date stamp 02/06/2003 3:53 PM.
Now in the automation script I am comparing this dateTime field with another date time stamp created in vbscript. The date time stap in vbscript is created by simply using the Now() command. So on my .log File I have:
02/06/2003 3:45 PM.
So in my recordselection formula I have tried EVERYTHING, nothing seems to work..this is what I currently have, I have tried other combinations of DateTime(Date(), DateTimeValue(Date(), etc....
Rept.recordselectionformula = "{@DateCombine} > Date(#" & strVal & "#)"
this always returns NO records for today..even though:
strVal = 02/06/2003 3:45 PM and "{@DateCombine}" = 02/06/2003 3:50 PM.
Basically, the initial date is being compared 02/06/2003 and nothing else. How do I do a full date comparision on a date time field? Please help. Thanks
*********************************************************
DateTimevar timeStamp;
timeStamp:=DateTime({TWDATA.LastChangeDate},{@convertNum})
***********************************************************
So in my report I have a date time field that reads like a date stamp 02/06/2003 3:53 PM.
Now in the automation script I am comparing this dateTime field with another date time stamp created in vbscript. The date time stap in vbscript is created by simply using the Now() command. So on my .log File I have:
02/06/2003 3:45 PM.
So in my recordselection formula I have tried EVERYTHING, nothing seems to work..this is what I currently have, I have tried other combinations of DateTime(Date(), DateTimeValue(Date(), etc....
Rept.recordselectionformula = "{@DateCombine} > Date(#" & strVal & "#)"
this always returns NO records for today..even though:
strVal = 02/06/2003 3:45 PM and "{@DateCombine}" = 02/06/2003 3:50 PM.
Basically, the initial date is being compared 02/06/2003 and nothing else. How do I do a full date comparision on a date time field? Please help. Thanks