Codejock Developer Community : Report Control - Formatting a date http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 27 May 2026 15:23:22 +0000 Tue, 22 Feb 2005 11:34:57 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=1038 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Report Control - Formatting a date : The Format property can now...]]> http://forum.codejock.com/forum_posts.asp?TID=1038&PID=5286&title=report-control-formatting-a-date#5286 Author: SuperMario
Subject: 1038
Posted: 22 February 2005 at 11:34am

The Format property can now be used to set the date format.

    '%a Abbreviated weekday name
    '%A Full weekday name
    '%b Abbreviated month name
    '%B Full month name
    '%c Date and time representation appropriate for locale
    '%d Day of month as decimal number (01 – 31)
    '%H Hour in 24-hour format (00 – 23)
    '%I Hour in 12-hour format (01 – 12)
    '%j Day of year as decimal number (001 – 366)
    '%m Month as decimal number (01 – 12)
    '%M Minute as decimal number (00 – 59)
    '%p Current locale’s A.M./P.M. indicator for 12-hour clock
    '%S Second as decimal number (00 – 59)
    '%U Week of year as decimal number, with Sunday as first day of week (00 – 53)
    '%w Weekday as decimal number (0 – 6; Sunday is 0)
    '%W Week of year as decimal number, with Monday as first day of week (00 – 53)
    '%x Date representation for current locale
    '%X Time representation for current locale
    '%y Year without century, as decimal number (00 – 99)
    '%Y Year with century, as decimal number
    '%z, %Z Time-zone name or abbreviation; no characters if time zone is unknown
    '%% Percent sign
    '%#c Long date and time representation, appropriatefor current locale. For example: “Tuesday, March 14, 1995, 12:41:29”.
    '%#x Long date representation, appropriate to current locale. For example: “Tuesday, March 14, 1995”.
    '%#d, %#H, %#I, %#j, %#m, %#M, %#S, %#U, %#w, %#W, %#y, %#Y Remove leading zeros (if any).


    Item.Format = "%a %m/%d/%Y %I:%M %p"


Edited by SuperMario]]> Tue, 22 Feb 2005 11:34:57 +0000 http://forum.codejock.com/forum_posts.asp?TID=1038&PID=5286&title=report-control-formatting-a-date#5286 <![CDATA[Report Control - Formatting a date : Format the date before you add...]]> http://forum.codejock.com/forum_posts.asp?TID=1038&PID=2692&title=report-control-formatting-a-date#2692 Author: SuperMario
Subject: 1038
Posted: 09 August 2004 at 6:22am

Format the date before you add it.  The "Format" property currently does not support this type of formatting. ]]> Mon, 09 Aug 2004 06:22:14 +0000 http://forum.codejock.com/forum_posts.asp?TID=1038&PID=2692&title=report-control-formatting-a-date#2692 <![CDATA[Report Control - Formatting a date : Hi, I was wondering if someone...]]> http://forum.codejock.com/forum_posts.asp?TID=1038&PID=2691&title=report-control-formatting-a-date#2691 Author: Maui
Subject: 1038
Posted: 09 August 2004 at 5:00am

Hi,

I was wondering if someone could advise me on the best way to format a date in the report control.

Assume I have entered Record.AddItem "09/08/2004 10:56:20"
But I want it displayed "9th August 2004"

Is this something I could use .format to do? If so could you please provide example showing how?

or would it be best to do it in the _BeforeDrawRow event?

or should I format it before I enter it into the report control?

Thanks

]]> Mon, 09 Aug 2004 05:00:10 +0000 http://forum.codejock.com/forum_posts.asp?TID=1038&PID=2691&title=report-control-formatting-a-date#2691