Support Forum Softcomplex logo
About Us  | Services  | Download  | Order  | Support  | |
| Search | Today's Posts | Stats | Board Rules | Not logged in [ Login | Register ]
go to bottom
Last active: Never

Printable Version | Subscribe | Add to Favourites   Post new thread
Author: Subject: Null date in date column
crysania
Newbie

Posts: 1
Registered: 2/5/2004
Member Is Offline
posted on 2/5/2004 at 08:45 AM Reply With Quote
Null date in date column


One of the columns in my table is a date column, but that date field is allowed to be null.

I've got my column type set to "date," since I need to be allow the user to sort by this field (with the assumption that a null date would be at the top of an ascending list).

However, set up this way, the records that do not have a date set yet will not load into the table, giving me the following message:
"Input date does not meet input date format."

I realize that I could switch this to a STR type to get my records with null dates to load fine, but then I lose the functionality of the "date" type, which we really don't want to do.

Are there any good solutions for this?
View User's Profile View All Posts By User U2U Member
tigra
Administrator

Posts: 2049
Registered: 6/17/2002
Location: US, CO
Member Is Offline
posted on 5/13/2005 at 05:42 PM Reply With Quote

attached is dt_parser.js that handles nulls in the data set.

Attachment: dt_parser.zip (1.46kb)
This file has been downloaded 1175 times
View User's Profile View All Posts By User U2U Member
gabysc
Newbie

Posts: 1
Registered: 2/9/2006
Location: Argentina
Member Is Offline
posted on 2/9/2006 at 03:51 PM Reply With Quote

I have seen that you have uploaded a new dt_parser file, i have tested it, and i notice that you are changin the null for the date of the day, and not for an empty cell space that it is what i need.

How can we put an empty cell in a date column, because we cannot loose the date functionality, but we cannot give a wrong information like the day of today.

Thanks in advance
View User's Profile View All Posts By User U2U Member
Post new thread

Related Links:
Product Page
Product Demonstrations Live Demos
Simple
XP-styled
3D designed
Product Documentation Documentation
Documenation Page
Change Log
Support Forum Technical Support
Support Forum
Customer Care System
Order Now ORDER NOW!
Add to Cart
View Cart

Go To Top


Powered by XMB 1.9.1 Nexus
Developed By Aventure Media & The XMB Group © 2002-2004