Timestamp not working

[#1]

So here is what happens,

Initial Data format

2010-12-05T00:30:00-05:00 so YYYY-MM-DDTHH:MM:SS-AA:BB

here is the code that I used

Timestamp#(left(replace(StartAt, 'T', ' '),19), 'YYYY-MM-DDhh:mm:ss.fff') as MyTimeStamp,

^^ this works as I can see expected result in list box

and then when I do (all of them do not work)

=Hour(MyTimeStamp)

=Floor(MyTimeStamp)

in expression for the title, or even in the load statement,I do not get the expected result !

Please help !

Thank you.

[MayilVahanan]

HI

Try like this

TimeStamp(Timestamp#(left(replace(StartAt, 'T', ' '),19), 'YYYY-MM-DDhh:mm:ss.fff') ,'YYYY-MM-DDhh:mm:ss.fff') AS MyTimeStamp;

[CELAMBARASAN]

You should use Timestamp function around the TimeStamp#

TimeStamp(Timestamp#(StartAt 'YYYY-MM-DDThh:mm:ss.fff') ,'YYYY-MM-DDhh:mm:ss.fff') AS MyTimeStamp;

if your splitting for some other string the use Left(StartAt, 20) in the place of StartAt

[#4]

Now nothing is working ! the listbox doesn't show dates any more for the field MyTimeStamp

[#5 · Accepted solution]

As suggested above,

this code worked for me :

TimeStamp(Timestamp#(left(replace(StartAt, 'T', ' '),19), 'YYYY-MM-DD hh:mm:ss[.fff]') ,'YYYY-MM-DD hh:mm:ss[.fff]') AS MyTimeStamp

Thank you for your help.