fixing the date

[Anonymous]

HI i have a date in this format 201310062300 and it's not correct i need to add 1 hour to it and at the same time  i want it to reflect on the day

for example

201310062300 should be 201310070000

any ideas

Thank you

[swuehl · Accepted solution]

=timestamp(Timestamp#('201310062300','YYYYMMDDhhmm') + MakeTime(1),'YYYYMMDDhhmm')

[CELAMBARASAN]

Try this

=Timestamp(Timestamp#(FieldName,'YYYYMMhhmmss') + MakeTime(1),'YYYYMMhhmmss')

Something is missing in the example you provided

2013(Year)10(month)06(hour)23(minute)00(seconds)

I don't see days here.

if you meant like 2013(Year)10(month)06(day)23(Hour)00(minute)

If the hours are in 24 hour format

=Timestamp(Timestamp#(FieldName,'YYYYMMDDHHmm') + MakeTime(1),'YYYYMMDDHHmm')