CODEWITHSUNDEEP
sqlsql-serverreporting-servicesssrs-2012
user2171512
user2171512

Reputation: 561

Cut seconds in DateTime field in SSRS

i have date and time in my sql serverdata base in this format:

2018-05-18 13:14:59.9277026

But when i use SSSRS reporting services and format that datetime field like

dd.MM.yyyy HH:mm

i loss seconds but SSRS round time and i get one more minute in report

Result in report is

2018-05-18 13:15

which is not ok for me. Any suggestion?

Upvotes: 0

Views: 604

Answers (1)

Mazhar
Mazhar

Reputation: 3837

try this format expression

 =CDate(Fields!data.Value).ToString("yyyy/MM/dd HH:mm:ss")

Upvotes: 1

Related Questions