Day_start Function

[adambrian]

Hi,

I want to use @day_start function. Can somebody help and tell me how to use that function?

I want to start everyday at 8am. I found this  formula, but i don't know to use it.

"DayStart(time[, [period_no[, day_start]])"

Thanks,

Adam

swr‌‌rtz‌mto‌

[arulsettu]

try this

DayStart('01-09-2016',1,1/3)

[millan123]

Hi please use this

Daystart(Now(),1,1/3)

[jpenuliar]

I think it is best explained in the help site:

daystart ‒ QlikView

[Chanty4u]

From Help file

Example	Result
daystart('25/01/2013 16:45:00')	Returns 25/01/2013 00:00:00.
daystart('25/01/2013 16:45:00', -1)	Returns 24/01/2013 00:00:00.
daystart('25/01/2013 16:45:00', 0, 0.5 )	Returns 25/01/2013 12:00:00.

[millan123]

hi

You got the correct answer?? then mark the Question as answered other wise ask we will try to solve

[adambrian]

can you explain more about "period_no". I'm not really understand about that. As example, I want to start at 8 am everyday and I am able to see the history of the data (> a week ago) . Much appreciate if u can help me to get better understanding.

[Chanty4u]

Hi

period_no

period_no is an integer, or expression that resolves to an integer, where the value 0 indicates the day that contains time. Negative values in period_no indicate preceding days and positive values indicate succeeding days.

[ToniKautto]

Can you elaborate more on the context in which you are looking for a 8AM day start? This function converts a timestamp to a day start time. Is that actually what you are looking for?

[jpenuliar]

Hi Adam,

Think of the period_no as an offset which you apply to the timestamp the function evaluates.

Are you trying to return data with a certain date and time range?

like from 29/08/2016 8AM to Today 8AM ?