convert string to timestamp am or pm

samsuf2002 · Post by **samsuf2002** » Wed Jan 09, 2008 9:43 am

Try the derivation given by ArndW and another way I suggest to do it as a substring, like date and time. U can change the date by using stringtodate() and keep the time as string to tranform it for am/pm using stage variables.

vilasini · Post by **vilasini** » Wed Jan 09, 2008 10:50 pm

Yes.Plz explain me how you have done it.

Thanks

samsuf2002 · Post by **samsuf2002** » Wed Jan 09, 2008 10:53 pm

what part of my post you dint understand ?

vilasini · Post by **vilasini** » Fri Jan 11, 2008 5:36 am

Thanks a lot for your response.Now the requirement is changed.

Regards
Anju

chulett · Post by **chulett** » Fri Jan 11, 2008 7:37 am

What the heck does that mean? Everything is fine now? We need to start over?

vilasini · Post by **vilasini** » Thu May 08, 2008 7:58 am

I have resolved it by checking with '/' of each and every combination of timestamp.I have defined 6 stage variables to convert.I cann't post variable derivation as it is very long.
I hope we can write a routine for that too.
Thanks