DateTime value as a String?

[ziggs]

In order to get my Crystal Reports via the web working properly, I was given this advise:

If the time component of your DateTime value is important to the parameter’s use, we suggest converting the existing parameter to a Date type, adding a String parameter for the time value, and using a function within Crystal Reports to combine these values into a single DateTime value. You can then use the DateTime value returned by the function in place of the original DateTime parameter.

How can this be done? I checked the help files and can't make heads or tails from it. [sig][/sig]

 

[Eshan98]

Where are you passing your parameters from?

 

[dcm]

ziggs: The function DateTime() will take a date and a time and combine them into one datetime field. Using your existing Date field is easy - to convert the Time string I suggest the following formula:

NumberVar hrs := Val(left(String,Instr(String,":&quot-1));
NumberVar mins:= Val(mid(String,Instr(String,":&quot+1));
NumberVar sec:=Val(right(String,if NumericText(right(String,2)) then 2 else 1)));

TimeVar mytime:=Time(hrs,mins,secs)

Hope this helps David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner