Hi Tauf: > Anyone run into and hopefully fix the date/time issue in Smart Reporting > where it evidently can't understand the concept of midnight!? > For example, using date measures like "yesterday" yields results from 12p > noon Changing the time to 12am still shows 12 noon. It only recognizes > 1am > onwards.
The resolution is to change the format of the date request: Please change the custom parameters of SR Data Source (In place of "HH" in time section make it "hh" as shown below DateTimeFormat=MM/dd/yyyy hh:mm:ss a;DateFormat=MM/dd/yyyy Regards, Chris _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
