Guriddo » Topic: Some trouble with filtering a date row

Some trouble with filtering a date row

Guriddo
date filter
Some trouble with filtering a date row

Tagged: date filter

This topic has 3 replies, 2 voices, and was last updated 6 years, 4 months ago by guriddo.support.

Creator

Topic
January 9, 2017 at 7:08 pm #125753
ddandre
Participant
Hello Guys,

i have some trouble with my grid. I try to filter this grid by a date that less than the given date. But there is no result. I think it depends on my declarion of the date row.
```
  $grid->setColProperty('tdUnixtimestamp',array(
 "label" => "Zeitpunkt", 
 'align' => 'center',
 'width' => 120,
 'datefmt' => 'u',
 'formatter' => 'date',
 'formatoptions' => array(
 'srcformat' => 'U',
 'newformat' => 'd.m.Y H:i'
 )
 ));
```
Any hints? Thx a lot
- This topic was modified 6 years, 4 months ago by ddandre.
- This topic was modified 6 years, 4 months ago by ddandre.
- This topic was modified 6 years, 4 months ago by ddandre.
Creator

Topic

Viewing 3 replies - 1 through 3 (of 3 total)

Author

Replies
January 10, 2017 at 10:30 am #125757
guriddo.support
Participant
Hello,

Did you set the datearray, user abd database date something like:
```
$grid->setUserDate('d.m.Y H:i');
$grid->setUserTime('d.m.Y H:i');
 
$grid->setDbDate('U');
$grid->setDbTime('U');
 
$grid->datearray= array( "tdUnixtimestamp" );
```
Kind Regards
Will

Guriddo Support Team
January 10, 2017 at 11:12 am #125758

ddandre
Participant

That works. Thanks.

is it possible to format the searchfield?

January 10, 2017 at 12:42 pm #125760

guriddo.support
Participant

Hello,

What you mean with format search field?

You can use the PHP setDatepicker function to use it in serch field formatting.

Please look at our demos:

Kind Regards,
Will

Guriddo Support Team
Author

Replies

Viewing 3 replies - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.

Stay connected with us in your favorite flavor!

Copyright 2014 TriRand LtdAll Rights ReservedRSS