Adding hours to date and time field

[#1]

Hi;

I have a field called [closed date] and would like to add 6 hours to this field. The field has date and time but is in general format and not a date and time format.How do l add 6 hours and have the result in date and time format?

Closed Date

28/10/2015 06:44

30/10/2015 04:21

01/11/2015 05:36

01/11/2015 02:57

31/10/2015 05:51

30/10/2015 11:04

10/11/2015 07:49

04/11/2015 04:51

04/11/2015 04:49

[sunny_talwar]

May be like this:

TimeStamp([Closed Date] + 6/24) as [Closed Date]

[MarcoWedel]

Hi,

one solution could be:

tabDates:
LOAD *,
    Timestamp([Closed Date]+'06:00','DD/MM/YYYY hh:mm') as [Closed Date +6hrs];
LOAD Timestamp#([Closed Date],'DD/MM/YYYY hh:mm') as [Closed Date]
FROM [https://community.qlik.com/thread/192197] (html, codepage is 1252, embedded labels, table is @1);

hope this helps

regards

Marco