Welcome, Guest
Username: Password: Remember me

TOPIC: [FIXED] Date missing from grid view

Date missing from grid view 03 Feb 2014 12:25 #12123

  • dyvel
  • dyvel's Avatar
  • Offline
  • Elite Member
  • Posts: 200
  • Thank you received: 11
  • Karma: 10
Hi

I've created 2 date fields for my table and added them to my collection view (grid) and on the form (edit) page.
When I add a date, it's not being displayed in the grid (all empty).

Formpage:


Grid:
Last Edit: 03 Feb 2014 12:25 by dyvel.
The administrator has disabled public write access.

Date missing from grid view 09 Feb 2014 12:38 #12165

  • BTB300
  • BTB300's Avatar
  • Offline
  • Moderator
  • Posts: 414
  • Thank you received: 130
  • Karma: 46
Hi All,
Finally Back on deck after Summer Holidays...

I think i have a similar issue however i think i found the solution (well perhaps workaround)

For me it was that i did not set the default format of the date field when defining the field in table

- table field Default format "inherited"
- Defining the format in the grid did not seem to fix
- date field value was not displayed in an fly view after save

The fix for me was to define the date format in the table field

I have confirmed this by leaving one of my date fields with no default format
- where the date format is defined in the table field as "dd-mm-yyy" for example - displays in grid view
- where the date format is defined in the table field as "inherited" - does not display in the grid views

Hope it helps

Additionally
- i did see dates when a saved / overwritten as 1999-11-30
- mysteriously it seemed that the date was overwritten with 1999-11-30 when displayed in a fly view (this could have been my mistake managed to build a j1.6 and install on J3.2)
The administrator has disabled public write access.

Date missing from grid view 09 Feb 2014 12:50 #12166

  • BTB300
  • BTB300's Avatar
  • Offline
  • Moderator
  • Posts: 414
  • Thank you received: 130
  • Karma: 46
Hi Admin
see my project test date display
The administrator has disabled public write access.

Date missing from grid view 09 Feb 2014 12:57 #12167

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 984
  • Karma: 140
I think I know because I remember to have fixed this, but still ???

Well, in the XML form, what is the generated format ?

If you want a default format, do not set empty string.
Cook was generating empty format parameter.
Better to remove the property, than leaving it empty.

Can you check that ? I am very busy.
Good news are coming...in the corner.
Coding is now a piece of cake
The administrator has disabled public write access.

Date missing from grid view 09 Feb 2014 13:02 #12169

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 984
  • Karma: 140
Or also in the grid ...
What is the dateFormat property ?
Try to remove it...

Dates are really more complex than it seems.
- Timezones,
- Formated strings recieved by the controller,
- Changed standard ('%Y-%m-%d %M:%S' becomed 'Y-m-d i:s')
- Difficulty to check a null date... 1900-00...

I faced all those problems in the past. Now Everyting is really quite stable...but still ???
Coding is now a piece of cake
The administrator has disabled public write access.

Date missing from grid view 09 Feb 2014 13:44 #12170

  • BTB300
  • BTB300's Avatar
  • Offline
  • Moderator
  • Posts: 414
  • Thank you received: 130
  • Karma: 46
No Worries
Will do some more digging on the issue for you tomorrow :)
The administrator has disabled public write access.

Date missing from grid view 12 Feb 2014 20:39 #12190

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 984
  • Karma: 140
Fixed now.
Coding is now a piece of cake
The administrator has disabled public write access.
Time to create page: 0.136 seconds

Get Started