Forum


20:21

19/08/2009

Hi,
I've got a datetime column in a 3.5 grid using cell editing. I'm trying to get validation happening and I have the following column definition:
{ name: "DTField", index: "DTField", label:"DTField", key: false, hidden: false, width: 140, sortable: true, datefmt:"dd/mm/yyyy H:i", resizable: true, editable: true, sorttype: "date", editrules:{required:true ,date:true}, formatter: "date", formatoptions:{mask: 'dd/mm/yyyy H:i'} , editoptions: { size: 20, dataInit: function(elem) { pickdatetime(elem,true); }} },
The part that doesn't work is the H:i bit. I can get this to work if I only have a date and I remove the H:i from the format and mask. My datetime picker is returning the date and time in a string of 27/08/2009 11:12 and that is getting rejected (error message comes up after edit) by the 'dd/mm/yyyy H:i' format.
Am I doing something wrong? I know I can remove the "date:true" param and then any datetime will be accepted, however I would really like to have the validation on.
Thanks,
Jo
05:21

Moderators
30/10/2007

Hello,
You do nothing wrong. The current date checking work only on date formats and not on datetime format.
Best Regards
Tony
For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.
Most Users Ever Online: 715
Currently Online:
56 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66