Extracting a Date from a timestamp?

[picnichouse]

Hi,

I have a field that stores the creation timestamp of every record. I'd like to run a report that groups records by the date... so is there a way to make a calculated field that only stores the date part of a timestamp?

Thanks!

Andrew

[Lee Smith]

Hi Andrew,

Maybe this post by comment will help you: Click Here

HTH

Lee

[comment]

Make the calculation = timestampField, and set the result to Date. That's all there is to it (the post mentioned by Lee is not about a true timestamp field).

[Lee Smith]

Oops

That is TOO EASY

I'm still thinking in V6, where you have to work a little for this stuff.

LOL

Lee

Edited November 6, 2005 by Guest