topic Re: Adding hours to date and time field in QlikView

Adding hours to date and time field

Thu, 19 Nov 2015 19:53:31 GMT

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

Re: Adding hours to date and time field

sunny_talwar — Thu, 19 Nov 2015 19:55:22 GMT

May be like this:

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

Re: Adding hours to date and time field

MarcoWedel — Thu, 19 Nov 2015 23:11:34 GMT

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