Tuesday, February 14, 2012

Display date in reports

How to display only the date part on reports from DateTime fields?

= format(fields!mydatefield.value,"mm/dd/yyyy")

or something like that.

|||Also how do I display the long form of DateTime?|||use the vb.net formatdate function... I'm sure you can lookit up quite easliy.|||Thanks I got it.

For Short form : =FormatDateTime(Fields!InputDate.Value, DateFormat.ShortDate)
For Long form : =FormatDateTime(Fields!InputDate.Value, DateFormat.LongDate)
For complete Date and Time : =FormatDateTime(Now, DateFormat.LongDate) & " " & FormatDateTime(Now,DateFormat.LongTime)

No comments:

Post a Comment