locked
SSRS Date Field RRS feed

  • Question

  • User265788195 posted

    I have a date field, =Fields!ModificationDate.Value. But its not showing any date. Not sure what I need to do.

    I added a textbox and attached this field and picked one of the date format from Number.. 

    Friday, April 18, 2014 5:25 PM

Answers

  • User724169276 posted

    Hello Nissan,

    Try this expression:

    =Format(Fields!ModificationDate.Value, "d")

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Saturday, April 19, 2014 12:14 AM
  • User-734925760 posted

    Hi,

    So far as I know, if we use Fields!ModificationDate.Value, the date type will be "mm:dd:yyyy hh:mm:ss", now you say the date is null, so we must make sure the Field's value.

    Also you can test the code as the above reply. Or you can test the code below:

    format(Fields!StartDate.Value,"mm/dd/yyyy")
    

    You must set this value to a date object.

    Hope it's useful for you.

    Best Regards,

    Michelle Ge

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, April 22, 2014 5:53 AM

All replies

  • User724169276 posted

    Hello Nissan,

    Try this expression:

    =Format(Fields!ModificationDate.Value, "d")

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Saturday, April 19, 2014 12:14 AM
  • User-734925760 posted

    Hi,

    So far as I know, if we use Fields!ModificationDate.Value, the date type will be "mm:dd:yyyy hh:mm:ss", now you say the date is null, so we must make sure the Field's value.

    Also you can test the code as the above reply. Or you can test the code below:

    format(Fields!StartDate.Value,"mm/dd/yyyy")
    

    You must set this value to a date object.

    Hope it's useful for you.

    Best Regards,

    Michelle Ge

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, April 22, 2014 5:53 AM