How to add the hours to date ?

[svsudhakar]

Hi ,

can any one please tell me how to add the 5 hours to date filed.

regards,

sudhakar Siram

[MK_QSL]

Do you mean to add 5 hour to TimeStamp Field or you want to add something like below?

Your Date 29/04/2014

Your New Date 29/04/2014 05:00:00

UPDATE : Use as below

=Timestamp#(Date(YourDateField) &' '& Time#('05:00:00'))

[its_anandrjs]

You have the time stamp date format or what means want to add the 5 hours to date field.

[svsudhakar]

Hi Anand,

I have the timestamp date format to that I need to add 5.30 hours.

[maxgro]

I think you have to just add 5.30/24

something similar to

=date(now() + 5.30/24, 'DD/MM/YYYY hh:mm:ss')

here for more on date and time

QlikView Date fields

[svsudhakar]

Hi Manish,

I need to add 5.30 hours to time stamp date filed . Format is like below

Ex: Date 29/04/2013 5.47.30

[lukaspuschner]

Hello,

this will work:

Timestamp((YourTimeStamp + Timestamp(MakeTime(5,30))),'DD/MM/YYYY hh.mm.ss')

[#8]

Hi,

Please try these in text objects and let me know this is how you required ?

=Date(Timestamp#('29/04/2014 17:00:39','DD/MM/YYYY HH:mm:s'),'DD/MM/YYYY HH:mm:s')

=Time('5:30','hh:mm')

=Date(Date(Timestamp#('29/04/2014 17:00:39','DD/MM/YYYY HH:mm:s'),'DD/MM/YYYY HH:mm:s')+Time('5:30','hh:mm'),'DD/MM/YYYY HH:mm:s')

[its_anandrjs]

Write like

=Timestamp( (now() + 5.30/24),'DD/MM/YYYY hh:mm:ss')

Or

=Timestamp( ( YourField + 5.30/24),'DD/MM/YYYY hh:mm:ss')

[MK_QSL]

=TIMESTAMP(YourFieldName+Time#('05:30:00','hh:mm:ss'))