none
Document map date format RRS feed

  • Question

  •  

    Hi all, I have produced a 'rdlc' report using Visual studio 2005 and have included a document map which is a list of dates.

    The dates which show in the document map are showing with the time as well, how to I get rid of the time on the dates as I only want the date to show?

    Thanks in advance

    Bryan

    Tuesday, July 8, 2008 7:34 PM

Answers

  • well I'll assume right now your document map label is set to something like


    Fields!ContractDate.Value


    and if you change it to an expression and use the following expression it should work

    =FormatDateTime(Fields!ContractDate.Value,2)



    2 being the format for date with no time


    Living my life at 123mph in 11.15 seconds
    • Edited by Blasty Tuesday, July 8, 2008 9:05 PM edited
    • Marked as answer by bryaninuk Wednesday, July 23, 2008 10:38 PM
    Tuesday, July 8, 2008 9:05 PM

All replies

  • well I'll assume right now your document map label is set to something like


    Fields!ContractDate.Value


    and if you change it to an expression and use the following expression it should work

    =FormatDateTime(Fields!ContractDate.Value,2)



    2 being the format for date with no time


    Living my life at 123mph in 11.15 seconds
    • Edited by Blasty Tuesday, July 8, 2008 9:05 PM edited
    • Marked as answer by bryaninuk Wednesday, July 23, 2008 10:38 PM
    Tuesday, July 8, 2008 9:05 PM
  • Fantastic! worked straight away.... easy when you know how!
    Thanks Bryan
    Wednesday, July 23, 2008 10:39 PM