Change "Day" from 06:00 AM to 05:59:59 AM next day

[amit_saini]

Hi Folks ,

Generally Our day in report is  from 00:00 to 23:59:59.But based on requirement i need to adjust it  from 06:00 to 05:59:59 next day.

Please suggest how this can be achieved.

Thanks,

AS

[qlikmsg4u]

Amit,

Try to add +0.25 to your timestamps, it will add 6 hrs to your timestamps.

Load*,Timestamp(DateTime+0.25) as Date;

Load * Inline [

DateTime

7/1/2009 5:23:00

7/1/2009 7:35:00

7/6/2009 13:34:00

7/6/2009 15:57:00

7/8/2009 17:55:00

7/8/2009 19:00:00

7/9/2009 23:50:00

7/9/2009 02:13:00

];

Here the bold dates changes to next day

Is this kind you are looking for?

[#3]

Try this,

=Date(Date(Date#(DateField,'MM/dd/YYYY HH:mm')) - (1/4), 'MM/dd/YYYY hh:mm.ss')

[Gysbert_Wassenaar]

You can use the DayStart and DayEnd functions and use 0.25 for the dayoffset parameter to shift the day's start and end six hours.

[amit_saini]

Hi Gysbert,

Below are calendar screenshot . After selection of Year, Month and Day i need to click on "Calender Selection" button to get the output and we are using below variables to do so:

vStart=timestamp(min(Date))

vEnd=Timestamp(max(Date))

Do i need to do +.25 changes inside these variables or somewhere else???

Note : We don't have any date filed , we are playing with variables to have calendar and time filters.

Thanks,
AS