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‌

[adambrian]

Hi Jonathan,

Yes, this is what i mean.

e.g : I want to look at log's analysis for last week until yesterday. But I want the start time is at 24/08/16 8AM last week until 31/08/16 8AM yesterday.

[jpenuliar]

If its in the Load script, we can make use of variables:

LET vDateStart = DayStart(Today()-7,0,0.33333333);

LET vDateEnd = DayStart(Today(),0,0.33333333);

Load

...........

...........

From

......................................

Where

where Date >= '$(vDateStart)' and Date<'vDateEnd'

;

[adambrian]

Thank you Jonathan. I will try this first. Will get back to you after i try.