Post reply

Date Formats

  • October 7, 2010 at 10:46 am

    #239494

    I searched but found many different formats, but not the one I'm looking for. Anyone know the syntax for this date format, October 1, 2010.

    I used this one, FormatDateTime(Parameters!EndDate.Value, 1) ....but this includes the name of day, which I dont need.

    Thanks!

  • October 7, 2010 at 11:23 am

    #1233792

    You will probably have to pull the date apart into pieces and then concatentate the pieces as strings using functions like MonthName, Day and Year.

  • October 7, 2010 at 11:50 am

    #1233820

    For what it is worth, here is how to return what you desire using T-SQL

    SELECT DATENAME (mm ,GETDATE()) + ' ' + CAST(DATEPART (dd, GETDATE()) AS

    VARCHAR(2)) + ', ' + CAST(DATEPART (yy, GETDATE()) AS VARCHAR(4))

    Returns: October 7, 2010

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • October 7, 2010 at 12:14 pm

    #1233842

    In the format properties of whatever control is displaying the date, put this: MMMM dd, yyyy

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

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