• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 410
  • Last Modified:

How do get only date from datetime in report

I have this:
=First(Fields!MyDate.Value, "dsetMyDataSet")

Open in new window

which returns date & time. I just want the date.
How to do this?
0
allelopath
Asked:
allelopath
1 Solution
 
Jason Yousef, MSSr. BI  DeveloperCommented:
Hi check that

http://www.jasonyousef.com/2012/03/ssrs-change-date-format-to-yyyy-mm-dd.html

=First(FormatDateTime(Fields!MyDate.Value,2), "dsetMyDataSet")

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now