Quarter Hour Grouping on DateTime Field

[mrichey]

I need to adapt the formula shown below (provided by sysvampire) to break the time into 15 minute (quarter-hour) intervals. I know it should be easy given the formula provided, but what can I say? Thanks!


Here's a formula for 1/2 hours for existing data:

datetime(year({Table.DateTimeField}),
month({Table.DateTimeField}),
day({Table.DateTimeField}),
hour({Table.DateTimeField}),
(
if minute({Table.DateTimeField}) < 30 then
0
else
30
)
,0)

-k

 

[lbass]

This depends upon how you treat time between the intervals, but using the same logic as before, you could use:

datetime(year({Table.DateTimeField}),
month({Table.DateTimeField}),
day({Table.DateTimeField}),
hour({Table.DateTimeField}),
(
if minute({Table.DateTimeField}) < 15 then
0 else
if minute({Table.DateTimeField}) in 15 to 29 then
15 else
if minute({Table.DateTimeField}) in 30 to 44 then
30 else
45
)
,0)

-LB

 

[synapsevampire]

Try:

datetime(year({Table.DateTimeField}),
month({Table.DateTimeField}),
day({Table.DateTimeField}),
hour({Table.DateTimeField}),
(
if minute({Table.DateTimeField}) < 16 then
15
else
if minute({Table.DateTimeField}) < 31 then
30
else
if minute({Table.DateTimeField}) < 46 then
45
else
0
)
,0)

sysvampire?

-k

 

[mrichey]

Thanks guys! That did it.

Sysvampire. LOL!!!

Sorry 'bout that. You're much too good to have your name mangled like that.

 

[synapsevampire]

Hmmm, I think that the name is already sorta self-mangled.

sysvampire sounds like some eeeeeee-vuhl whacked out hacker

-k