Format date and numbers

  • i want the dates to be formated in mm/dd/yyyy for a field. Field might contain 1/1/2009 which should be 01/01/2009

    please let me know how to do in the expression builder of that field

  • http://www.java2s.com/Code/SQLServer/Date-Timezone/Formatdatemmddyyyy.htm

    there's a few examples at the bottom.

    as long as you realise that if you sort by these dates it sorts as a string and not a date.

  • i am trying to do in the SSRS field expression. i am not doing a sort with the date.

  • Why you are trying to do in field expression?. You can achieve this while selecting the date from table using sql query.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------
    Please feel free to let me know if you are not clear or I’ve misunderstood anything.

    Thanks,
    Arunkumar S P

  • =format(Fields!FieldName.Value,"MM/dd/yyyy")

    View Siva Gurusamy's profile on LinkedIn

    "Software changes. This is a rather obvious statement, but it is a fact that must be ever present in the minds of developers and architects. Although we tend to think of software development as chiefly an engineering exercise, the analogy breaks down very quickly. When was the last time someone asked the designers of the Empire State building to add ten new floors at the bottom, put a pool on the top, and have all of this done before Monday morning? " : Doug Purdy, Microsoft Corporation

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply