Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I have this format 2014.07.31 23.00 which i would like to add 1 hour so it would change the date from 07.31 to 08.01 the rest of the hours will be shifted +1 i mean
Here format is crucial, be sure about the format you have in starttime field and the one you are using in timestamp#() are similar. Even spaces in between matter. if there is a space in between date part and hour part try like:
Timestamp(Timestamp#(starttime,'YYYYMMDD hhmm')+(1/24)) as test1,
YourDateColumn + (1/24)
Should do the trick.
Hi,
Try below.
Load Timestamp((Date + Timestamp(MakeTime(1,00))),'DD/MM/YYYY hh.mm.ss') as Date1;
load Date(date#(Date_Time,'YYYY.MM.DD h.mm'),'M/D/YYYY h:mm:ss[.fff] TT') as Date;
load * Inline
[
Date_Time
2014.07.31 23.00
]
Regards
ASHFAQ
it's not working
someone told me about this function but it's not working anymore
=Timestamp(Timestamp#(FieldName,'YYYYMMDDHHmm') + MakeTime(1),'YYYYMMDDHHmm')
can you help ?
Hi Tamer,
Try this, It should work.
=timestamp(Timestamp#('2014.07.31 23.00 ', 'YYYY.MM.DD hh.mm')+(1/24))
OR
If you want to specify the format use below
=timestamp(Timestamp#('2014.07.31 23.00 ', 'YYYY.MM.DD hh.mm')+(1/24),'YYYY.MM.DD hh.mm')
Regards
Manideep
Hi,
Its working.
I have tried you can even try by copy my code to new qvw file and try to replicate the same.
Regards
ASHFAQ
the below is what i write in the code but it returns nothing
Timestamp(Timestamp#(starttime,'YYYYMMDDhhmm')+(1/24)) as test1,
Here format is crucial, be sure about the format you have in starttime field and the one you are using in timestamp#() are similar. Even spaces in between matter. if there is a space in between date part and hour part try like:
Timestamp(Timestamp#(starttime,'YYYYMMDD hhmm')+(1/24)) as test1,
this is the time format i have
2014.08.06 20.00
thanks a lot it's working