String Convert Time 1

[soushi01]

Hi,

How to let String convert to Time like this

"090204 AM" convert to this--> 09:02:04 AM
"234534 PM" convert to this--> 23:45:34 PM

thanks
Regards
s1

 

[IanWaterman]

Just break it down and concatenate

@time
left(timefield, 2)&':'& mid(timefield,3, 2)&':'&mid(timefield,5, 2)&' '&right(timefield, 2)

Ian

 

[soushi01]

Hi,

Im Newbie crystal report user,
may i know in crystal report hv this function (as i know in Java Programming function called "String Buffer: deleteCharAt ")

Means that "90204 AM" or "234534 PM" , i just want to remove "AM" or "PM" , so it my expected display the value "234534"


thanks

regards,
s1

 

[IanWaterman]

There is no Crystal function.

You can create a custom function which does the above.

To show just the numbers

@time2
left(timefield, 6)

Ian

 

[soushi01]

Hi, Ian

Very thank you so much for the help
Is works great , and thanks for the information


regards,
s1