SQLTeam.com | Weblogs | Forums

Formating date issue


#1

I am using: =Format(CDate(First(Fields!startdate.Value,"DataSet4")),"MM/dd/yyyy")

to try to format "06/10/2015 00:00:00:000 -04:00"

But I am not having any luck. Any idea?
Also I will need to for mat the UTC on another field. Not sure how to do that too


#2

Based on my reading of this page, it looks like you should get rid of the offset before formatting like shown below rather than use CDate.

=Format(First(Fields!startdate.Value.DateTime,"DataSet4"),"MM/dd/yyyy")

Disclaimer: I haven't tried it, so...


#3

This just gives me an error