Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I searching through the forums to find an example that will work, I'm having a hard time finding something that's not an exact 4 hour interval though. Here's my situation:
1) I get a timestamp that's in GMC, I need to:
a. Convert to CST. I don't have an issue with this. using: time(ConvertToLocalTime(LogTimeStamp,'Central Time (US & Canada)')) to make this work.
b. Take into account Daylight Savings Time (DST). I think the conversion in a will keep the DST in mind.
c. Bucket the times (dates do not matter) into specific groupings.
The groupings have me confounded. I just want to bucket between the each time frame for example:
Bucket 1 03:30 AM to 10:59 AM, Bucket 2 11:00 AM to 3:29 AM, etc.
Any guidance would be appreciated.
Take a look at the attached qvf. I used the "Previous" function... Here's the output:
As for the DST, check out the 3rd argument on the "ConvertToLocalTime" function