I have a dataset in Reporting Services that basically just populates a report parameter field automatically for me. The small peice of SQL that I run is
SELECT MAX (src_date) AS LatestMonth
FROM dbo.tbl_src_date
The problem I have is a visual one in that it all works but the output that is placed in the relevant report parameter box is mm/dd/yyyy hh:mm:ss.
All I want to see in this box is dd/mm/yyyy and no time. On top of this I also wish it to select the hoghest date value it finds in the query result hence the MAX statement. How can I convert the datetime to the format I want and run a MAX statement at the same time?
Thanks in advance
SELECT MAX (src_date) AS LatestMonth
FROM dbo.tbl_src_date
The problem I have is a visual one in that it all works but the output that is placed in the relevant report parameter box is mm/dd/yyyy hh:mm:ss.
All I want to see in this box is dd/mm/yyyy and no time. On top of this I also wish it to select the hoghest date value it finds in the query result hence the MAX statement. How can I convert the datetime to the format I want and run a MAX statement at the same time?
Thanks in advance
Last edited: