TIME FORMAT IN CRYSTAL

[ronkus]

Please i would need any suggestions of help reagarding this.

I have a TIME field which, when generated in Crystal with the formula created for it, it populates the wrong time, the reason why i would need a time formula is so that it does not generate the field in a number format.
The formula created is:

DateAdd('s',{Incident_Managemnt_Form.From_x},#00:00:00#)
therefore if the correct time for a particular case is 15:00, it generates the report as 14:00. It is the same for all the other reports for a time field.
Guess there is something missing in the formula i have written. please reply soon.

Thanks

 

[synapsevampire]

If you need to convert seconds to a HH:MM:SS, then use the following.

If you're trying to fabricate some sort of time, I've no idea what you're trying to do.

whileprintingrecords;
numberVar dur:=,{Incident_Managemnt_Form.From_x};
numberVar hrs;
numberVar min;
numberVar sec;
stringVar hhmmss;

hrs := Truncate(Truncate(dur/60)/60);
min := Remainder(Truncate(dur/60),60);
sec := Remainder(dur,60);

//hhmmss := totext(hrs, "0&quot + ":" + totext(min, "00&quot + ":" + totext(sec, "00.0", 1);
hhmmss := totext(hrs, "0&quot + ":" + totext(min, "00&quot + ":" + totext(sec, "00"

hhmmss

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com