Jim Metcalf
asked on
ssrs edit the way the data is displayed in 1 column
I have a field that is showing the value of date and time. i want it to only show date.
I have used the cast function in the query itself for the dataset to cast the datetime variable to strictly date.
so the query itself only shows the date but in the report it shows date and time.
when i click on the expression for the column in question i get....=Fields!Completed_D ate.Value
is there a way i can edit the aforementioned expression to only display date.
if there is a better way to do this, i am open to options
I have used the cast function in the query itself for the dataset to cast the datetime variable to strictly date.
so the query itself only shows the date but in the report it shows date and time.
when i click on the expression for the column in question i get....=Fields!Completed_D
is there a way i can edit the aforementioned expression to only display date.
if there is a better way to do this, i am open to options
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.