Selecting the Max daily timestamp

[rob11nj]

I'm trying to work only with those rows of data that are the most recently updated each day (maximum timestamp for each day) but I'm running into some problems.

I've tried creating a formula field with the following:
Maximum({DEVICE_ALLOCATION.TIMESTAMP},{DEVICE_ALLOCATION.TIMESTAMP},"daily")

I thought that this would give me the maximum timestamp for each day but I keep recieving the following error:

"There must be a group that matches this field."

Not really sure what that means or where to go from here. I would think that this should be fairly simple.
Any help would be much appreciated!

 

[lbass]

You have to insert a group on {DEVICE_ALLOCATION.TIMESTAMP}. Is this a datetime field or just a time field? Check the datatype by running your mouse over the field so you can see the tooltip text.

-LB

 

[rob11nj]

Ahhh thats it, I actually did have the group but it was being printed each second instead of each day... just changed the group to daily and it's not throwing any errors at me anymore.

Thanks!