komal145
SSCrazy Eights
Points: 9918
More actions
July 2, 2012 at 12:06 pm
#260784
I have something like this:
2012-04-23 10:54:29.070
i need to get only something like this:
2012-04-23 10:54 In SSRS expressions.
Can anyone tell me how to do this in expressions??
Thanks in Advance
Daniel Bowlin
SSC-Dedicated
Points: 34566
July 2, 2012 at 1:47 pm
#1507912
You can do this in the dataset query
SELECT CONVERT(VARCHAR(16),GetDate(),20)
where you substitute your date column for GetDate()
Or you could put this in the Format property of the textbox
yyyy-MM-dd h:mm
July 2, 2012 at 3:52 pm
#1507954
Thank you
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply