Help with time shift formula using MINIMUM for group 1

[elsenorjose]

Hello all,

I need to shift the datetime portion of this formula but I can't find a good example in the CR help file. Can someone please assist? I am using CR XI.

minimum({usrTask_ALL.StartDateTimeUTC},{usrTask_ALL.TaskName})

Basically I want the first occurrence of the Task Name based on the StartDateTimeUTC but with the StartDateTimeUTC shifted like this:

shiftdatetime({usrTask_ALL.StartDateTimeUTC},",0",",720")

 

[lbass]

I think you can just plug your first formula into the second one instead of the datetime field.

-LB

 

[elsenorjose]

Thanks LB. I had tried just inserting it the other way around, putting the shifted datetime into the first formula. Your solution is working perfectly.