get the date part of the date field

Question

I have a date field containing hour, minute.  What function should I use in SSRS to get the date part

---

Thank You Warmest Fanny Pied

Answer 1

1. =Format(Fields!YourDateField.Value,"MM/DD/YY")

2. =FormatDateTime(Fields!YourDateField.Value, 2)

3. =Split(Fields!YourDateField.Value," ")(0) -- if value is string

---

Please mark as answered or vote helpful if this post help resolved your issue. Thanks!

k r o o t z

Answer 2

Thank you, very helpful

---

Thank You Warmest Fanny Pied