topic Re: fixing the date in QlikView

fixing the date

Anonymous — Tue, 08 Oct 2013 09:39:03 GMT

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 — Tue, 08 Oct 2013 09:41:44 GMT

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

CELAMBARASAN — Tue, 08 Oct 2013 09:48:36 GMT

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')