Report GMT datetime to CET Datetime

Question

Post reply

Report GMT datetime to CET Datetime

arjunabhimonu

SSC Enthusiast

Points: 113
More actions
October 16, 2014 at 9:15 am

#297521

Report GMT datetime to CET Datetime
I have a query returning GMT time and users wants to see the time in CET , how and where do i make this conversion in the report ? Pls reply asap.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

sql_lock SSCrazy Eights Points: 9373 More actions · Answer 1

For a quick fix you could just use the DATEADD function in SSRS.

Caution: This will also be applied to all users and be weary of daylight savings

arjunabhimonu SSC Enthusiast Points: 113 More actions · Answer 2

Thank you . I am new to SSRS and am using report builder.

can you tell me where in report builder i need to use this function? ( Is it in column-> F4 properties-> Format ?)

also currently my query output is returning 24hrs format ... but my report is showing AM/PM - i need to change that .. can you tell me where to make this change pls

sql_lock SSCrazy Eights Points: 9373 More actions · Answer 3

You will need to create a new field to replace the existing data using an expression.

=DateAdd(DateInterval.Hour, -6, now() )

** Replace now() with your datetime field from you're dataset

arjunabhimonu SSC Enthusiast Points: 113 More actions · Answer 4

Thanks - I was able to create a calculate field and used DATEADD function to convert time GMT to CET.

how ever my my query output is returning 24hrs format ... but my report is showing AM/PM - i need to change that .. can you tell me where to make this change pls

once agian- thank you so much.

pietlinden SSC Guru Points: 63503 More actions · Answer 5

dates are numbers, so change the formatting in the textbox properties.