Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
adambrian
Contributor III
Contributor III

Day_start Function

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‌‌rtzmto

12 Replies
arulsettu
Master III
Master III

try this

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

millan123
Creator II
Creator II

Hi please use this

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

jpenuliar
Partner - Specialist III
Partner - Specialist III

I think it is best explained in the help site:

daystart ‒ QlikView

Chanty4u
MVP
MVP

From Help file

ExampleResult
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
Creator II
Creator II

hi

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

adambrian
Contributor III
Contributor III
Author

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
MVP
MVP

Hi

period_noperiod_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
Employee
Employee

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
Partner - Specialist III
Partner - Specialist III

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 ?