Hello,

I am trying to display a specific date time in my report based upon a start date parameter entered.  For example, if the user enters a start/open date of 7/1/10 hh:mm:ss, then in the report I want it to display 6/30/10 11:59:59 PM, the previous date at 11:59:59.

Is there a simple formula that will do this?

Thanks in advance and let me know if I've posted in the place.

Ohh man, that is so slick!

Thank you so much!!!

oops. sorry about that.