Hello Experts,
I have a hyperlink in a report and having prompt (from-date and to-date)in the target report. I am trying to pass From-date to target report from the source as it is.But want to pass to-date till 23 hours only.
For ex. if Source date is-28/06/2010 00:00 (always) then to-date shud be till 28/06/2010 23:00 only.
I am trying to use following formula to get this but its displaying value for next day’s 00:00 hrs i.e. 29/06/2010 00:00.
=FormatDate(RelativeDate([Hourly];1);“M/d/yyyy”)
Please assist.
vijesh.chandra 
(BOB member since 2009-05-29)