http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 27 May 2026 11:25:35 +0000 Fri, 05 Nov 2004 14:23:52 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=1359 http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ http://forum.codejock.com/forum_posts.asp?TID=1359&PID=3874&title=propertygriditem-date-format-and-null#3874 Author: SuperMario
Subject: 1359
Posted: 05 November 2004 at 2:23pm

So far, in the next release you will be able to bind items of typePropertyItemDate.  Just to let you know, this has been sent todevelopment and we are waiting for a response]]> Fri, 05 Nov 2004 14:23:52 +0000 http://forum.codejock.com/forum_posts.asp?TID=1359&PID=3874&title=propertygriditem-date-format-and-null#3874 http://forum.codejock.com/forum_posts.asp?TID=1359&PID=3872&title=propertygriditem-date-format-and-null#3872 Author: dlord
Subject: 1359
Posted: 05 November 2004 at 1:58pm

I've got the same issue and asked about it in the PropertyGrid Forums, but no replies. I do think the date format is a fairly major issue...!

Edited by dlord]]> Fri, 05 Nov 2004 13:58:17 +0000 http://forum.codejock.com/forum_posts.asp?TID=1359&PID=3872&title=propertygriditem-date-format-and-null#3872 http://forum.codejock.com/forum_posts.asp?TID=1359&PID=3800&title=propertygriditem-date-format-and-null#3800 Author: shildreth
Subject: 1359
Posted: 02 November 2004 at 10:49am

Hi,

I am using the PropteryGrid and this statement:
Set Item = Category.AddChildItem(PropertyItemDate, "Release Date", adoRSLookup.Fields("user_release_date") & "")

The date format in the SQL table is '2004-10-01' but when the property grid displays '01/10/2004'

I have tried item.format = "mm/dd/yyyy" with no luck, and I cant seem to find the docs on this.

Oh and if the value is NULL got any sexy way of handling that? I put anIf then and change the property value, because I dont want the'01/01/2004' date to appear when the value is in the database. Here ishow I handled it:

If Not IsNull(adoRSLookup.Fields("user_release_date")) Then
   Set Item = Category.AddChildItem(PropertyItemDate, "Release Date",adoRSLookup.Fields("user_release_date") & "")
    Item.Description = "user_release_date"
Else
    Set Item = Category.AddChildItem(PropertyItemString, "Release Date", "---")
    Item.Description = "user_release_date"
End If

I would love to hear how I am a chucklehead and be pointed in a better direction.

Thanks for any help,
Regards,
Steven

]]> Tue, 02 Nov 2004 10:49:42 +0000 http://forum.codejock.com/forum_posts.asp?TID=1359&PID=3800&title=propertygriditem-date-format-and-null#3800