Date Time to Time Text - 24 hr format 1

[reportdr]

Hello

I am working with Crystal 8.0 on a Windows XP/SP2 computer accessing an ODBC database.

I am creating a report for a 3rd party vendor that must be in fixed length fields. I have the fixed length part figured out for most of the report but I'm having difficulties in getting a date/time field to show up as time only in the 24 hour clock format.

My current formula is:

numbervar requiredlength:=5;
numbervar currentlength:=Length(Trim(ToText({DB.TRIAGEDATE},"hh:mm")));

if currentlength<requiredlength then
Trim(ToText({DB.TRIAGEDATE},"hh:mm"))+replicatestring(" ",requiredlength-Length(Trim(ToText({DB.TRIAGEDATE},"hh:mm"))) ) else
if currentlength>=requiredlength then
left(ToText({DB.TRIAGEDATE},"hh:mm"),requiredlength)

Tbis works but doesn't show the time in 24 hour clock format. Thanks in advance.

S.

 

[lbass]

Try changing the lowercase "hh:mm" to "HH:mm". I think this will change the result to 24-hour time.

-LB

 

[reportdr]

You are the absolute greatest!!! A big huge star to you! (as you can tell from my reaction it worked!!)

I also want to thank you for your efforts on this site - you must visit thie site daily, ALWAYS answers questions and are very polite and positive while doing so. You never make people feel stupid and for that I am grateful!

Thanks again LB!

S.

 

[lbass]

Thank you for the nice comments. Glad it worked for you.

-LB