Page 2 of 2

Posted: Wed Jan 09, 2008 9:43 am
by samsuf2002
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.

Posted: Wed Jan 09, 2008 10:50 pm
by vilasini
Yes.Plz explain me how you have done it.

Thanks

Posted: Wed Jan 09, 2008 10:53 pm
by samsuf2002
what part of my post you dint understand ?

Posted: Fri Jan 11, 2008 5:36 am
by vilasini
Thanks a lot for your response.Now the requirement is changed.

Regards
Anju

Posted: Fri Jan 11, 2008 7:37 am
by chulett
What the heck does that mean? Everything is fine now? We need to start over? :?

Posted: Thu May 08, 2008 7:58 am
by vilasini
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