Formatted dates with Luxon
This example includes multiple date formats that are not in the standard format to demonstrate how SearchBuilder operates with formatted dates. It makes use
of the datetime()
function that is built into DataTables to format dates with either Moment.js or Luxon, depending on what is available on the page (in this case Luxon).
Name | Company | Created | Updated |
---|---|---|---|
Dai Weeks | Eu Foundation | 11:10 Oct 18, 14 | Sat, May 16, 2015 |
Jade Dale | Sit Amet Inc. | 07:04 Apr 29, 14 | Sat, July 25, 2015 |
Melanie Buckner | Tempus Lorem LLC | 02:01 Jan 28, 15 | Sun, October 11, 2015 |
Cyrus Haney | Phasellus Corp. | 10:01 Jan 28, 14 | Sat, December 28, 2013 |
Melinda Salas | Molestie Sed Id Limited | 11:05 May 1, 14 | Fri, May 15, 2015 |
Rebecca Cline | Eget Dictum Placerat Limited | 02:12 Dec 20, 13 | Wed, August 6, 2014 |
India Lawson | Eget Company | 11:03 Mar 21, 15 | Fri, July 11, 2014 |
Elvis Whitfield | Mollis Corporation | 08:07 Jul 30, 15 | Sat, February 28, 2015 |
Castor Monroe | Iaculis LLC | 12:06 Jun 22, 14 | Mon, June 2, 2014 |
Gareth Berry | Malesuada Corp. | 04:02 Feb 26, 14 | Fri, February 27, 2015 |
Anne Knox | Neque Sed Consulting | 04:04 Apr 11, 14 | Sat, May 24, 2014 |
Kasimir Martin | Tortor Nunc Consulting | 11:12 Dec 24, 14 | Sat, July 25, 2015 |
Drake Pugh | Mattis Velit Industries | 03:09 Sep 23, 15 | Wed, March 5, 2014 |
Carla Head | Pretium Aliquet Institute | 06:09 Sep 2, 15 | Wed, January 8, 2014 |
Shellie Henry | Scelerisque Ltd | 11:01 Jan 28, 15 | Sun, February 1, 2015 |
Patrick Koch | Scelerisque Dui LLC | 10:10 Oct 3, 14 | Sun, May 17, 2015 |
Dara Roberts | Urna Convallis Erat Industries | 11:08 Aug 13, 15 | Sun, June 22, 2014 |
Yuli Wright | Auctor Consulting | 05:07 Jul 22, 14 | Tue, March 25, 2014 |
Cyrus Jensen | Et Risus Associates | 10:09 Sep 19, 15 | Sat, May 16, 2015 |
Holmes Talley | Urna Nullam Lobortis Consulting | 01:12 Dec 25, 14 | Thu, February 13, 2014 |
Iris Carver | Laoreet Lectus Quis LLC | 12:10 Oct 13, 14 | Fri, November 7, 2014 |
Leroy Cantrell | In LLC | 03:05 May 5, 15 | Tue, June 2, 2015 |
Maggie Aguilar | Mauris PC | 02:12 Dec 7, 14 | Thu, November 20, 2014 |
Maggy Porter | Mauris Blandit Ltd | 11:06 Jun 4, 14 | Tue, November 11, 2014 |
Liberty Warner | Ipsum Company | 05:11 Nov 17, 15 | Mon, October 5, 2015 |
Raya Dean | Felis Foundation | 02:12 Dec 18, 14 | Mon, February 10, 2014 |
Jack Juarez | Nunc Limited | 01:09 Sep 7, 15 | Mon, December 22, 2014 |
Nola King | Varius Orci Incorporated | 04:05 May 12, 15 | Tue, June 24, 2014 |
Carlos Holman | Odio LLC | 01:08 Aug 16, 15 | Thu, August 20, 2015 |
Aquila Finch | Egestas Ligula Nullam Institute | 12:09 Sep 3, 15 | Sat, March 22, 2014 |
Seth Porter | Sem Ut Inc. | 01:06 Jun 4, 15 | Sun, March 1, 2015 |
Oleg Mcpherson | Nunc Ac Sem LLP | 03:08 Aug 3, 14 | Sun, September 21, 2014 |
Kennan Snyder | Amet Consectetuer Associates | 06:01 Jan 23, 14 | Mon, April 7, 2014 |
Emery Donovan | Dapibus Inc. | 08:06 Jun 14, 14 | Tue, September 30, 2014 |
Naida Hunter | Augue Scelerisque Mollis Inc. | 11:12 Dec 23, 13 | Sun, July 19, 2015 |
Clinton Morrison | Non Lacinia Industries | 02:03 Mar 18, 14 | Fri, March 6, 2015 |
Helen Gutierrez | Faucibus Incorporated | 07:08 Aug 7, 15 | Tue, February 4, 2014 |
Candice Bonner | Donec LLP | 05:12 Dec 28, 13 | Mon, March 16, 2015 |
Nissim Carter | Suspendisse Sed Limited | 01:03 Mar 19, 14 | Mon, June 29, 2015 |
Kasimir Hoffman | Id Libero Donec Consulting | 05:12 Dec 23, 14 | Wed, September 23, 2015 |
Imogene Mcconnell | Vitae Associates | 07:02 Feb 17, 15 | Tue, July 22, 2014 |
Sage Mosley | Metus In Inc. | 05:05 May 24, 15 | Mon, April 21, 2014 |
Sybil Puckett | Vel Lectus LLP | 09:06 Jun 9, 14 | Sat, September 6, 2014 |
Kylynn Solis | Ac Limited | 10:01 Jan 20, 15 | Tue, September 15, 2015 |
Beatrice Hurley | Mauris A Nunc Corporation | 04:05 May 11, 14 | Sun, April 26, 2015 |
Troy Marquez | Dapibus Quam Institute | 12:02 Feb 7, 15 | Thu, April 23, 2015 |
Malcolm Payne | Adipiscing Ligula Institute | 04:08 Aug 17, 15 | Tue, September 2, 2014 |
Wade Valenzuela | Sagittis Duis Gravida Corporation | 03:05 May 22, 14 | Mon, January 13, 2014 |
Kathleen Gilmore | Urna Nec Ltd | 05:03 Mar 5, 14 | Mon, November 16, 2015 |
Maite Scott | Ipsum Cursus Inc. | 01:05 May 28, 14 | Sun, June 8, 2014 |
Kamal Nash | Sem Vitae Company | 05:10 Oct 7, 14 | Thu, June 26, 2014 |
Iliana West | Ac Eleifend Limited | 01:10 Oct 24, 15 | Wed, July 2, 2014 |
Susan Osborn | Sollicitudin Adipiscing Ligula Institute | 03:02 Feb 18, 14 | Sat, June 13, 2015 |
Adena Carter | Nibh Industries | 04:01 Jan 27, 15 | Tue, February 3, 2015 |
Duncan Mckinney | Vel Convallis In Inc. | 09:11 Nov 23, 15 | Sat, December 12, 2015 |
Ariana Whitehead | Fermentum Metus Associates | 03:06 Jun 9, 14 | Tue, December 15, 2015 |
Fiona Henderson | Eget Tincidunt Dui Inc. | 03:01 Jan 1, 14 | Fri, January 9, 2015 |
Judah Gates | Donec Felis Associates | 04:11 Nov 30, 15 | Mon, September 28, 2015 |
Hasad Mccarthy | Ac Tellus Company | 12:01 Jan 21, 14 | Mon, January 27, 2014 |
Shay Valencia | Natoque Associates | 05:03 Mar 4, 14 | Mon, December 15, 2014 |
Hillary Tran | Integer Mollis Foundation | 08:12 Dec 31, 14 | Wed, August 26, 2015 |
Margaret Sellers | Lacus Quisque Corporation | 11:10 Oct 17, 15 | Sun, July 5, 2015 |
Prescott Morton | Vestibulum Associates | 01:04 Apr 27, 15 | Sun, June 14, 2015 |
Charity Gilbert | Tortor At Risus Associates | 01:07 Jul 31, 14 | Thu, December 18, 2014 |
Freya Randolph | Ut Institute | 07:11 Nov 3, 15 | Sat, September 27, 2014 |
Nita Howe | Ornare Fusce Inc. | 11:02 Feb 12, 14 | Tue, June 9, 2015 |
Kirby Whitney | Faucibus Morbi Vehicula Foundation | 11:12 Dec 22, 13 | Wed, August 26, 2015 |
Amos Jarvis | Mauris Suspendisse Aliquet LLP | 01:05 May 10, 15 | Mon, July 14, 2014 |
Kim Hunter | Ligula Donec Luctus Corp. | 07:11 Nov 25, 15 | Thu, October 23, 2014 |
Rosalyn Benton | Iaculis Quis Pede Corp. | 02:09 Sep 16, 14 | Sun, November 15, 2015 |
Anjolie Floyd | Nunc Corp. | 12:03 Mar 28, 14 | Mon, December 1, 2014 |
Basil Harmon | Semper Rutrum Fusce PC | 05:12 Dec 9, 15 | Wed, September 17, 2014 |
Kermit Herrera | Sed Tortor Integer Limited | 03:09 Sep 26, 14 | Sun, June 14, 2015 |
Winifred Pearson | Augue Industries | 10:09 Sep 18, 15 | Tue, August 4, 2015 |
Lester Fischer | Aenean PC | 02:09 Sep 15, 15 | Wed, July 29, 2015 |
Tatum Daugherty | Nunc Nulla LLP | 09:06 Jun 25, 15 | Wed, February 19, 2014 |
Zachary Wilder | Nec LLC | 03:09 Sep 19, 14 | Wed, April 8, 2015 |
Laith Peters | Ipsum Leo Elementum Institute | 11:06 Jun 17, 14 | Thu, November 13, 2014 |
Evelyn Ramos | Nunc Industries | 01:06 Jun 3, 14 | Thu, April 10, 2014 |
Mara Michael | Ut Aliquam LLC | 10:07 Jul 14, 14 | Thu, November 26, 2015 |
Jemima Powers | Eu Arcu Morbi LLP | 06:08 Aug 4, 14 | Fri, May 1, 2015 |
Tanek Guthrie | Sit Associates | 09:02 Feb 19, 15 | Thu, May 28, 2015 |
Harriet Crane | Quis Accumsan Ltd | 12:08 Aug 2, 14 | Sun, December 13, 2015 |
Jin Bond | Auctor Quis Corp. | 09:08 Aug 25, 15 | Tue, November 18, 2014 |
Ursa Jacobs | Convallis Ante PC | 08:04 Apr 5, 14 | Tue, February 18, 2014 |
Jason Collier | Vel Pede Blandit Ltd | 01:05 May 12, 14 | Mon, September 21, 2015 |
Quemby Stone | Lacus Quisque Incorporated | 09:08 Aug 10, 15 | Thu, July 2, 2015 |
Melvin Sweet | Nec Foundation | 05:01 Jan 17, 15 | Thu, May 22, 2014 |
Thor Wilson | Arcu Vivamus Sit Industries | 02:02 Feb 17, 15 | Thu, August 7, 2014 |
Burton Marquez | Augue Corporation | 09:12 Dec 2, 15 | Wed, November 26, 2014 |
Kai Ware | Facilisis Vitae Limited | 12:06 Jun 23, 14 | Sun, June 29, 2014 |
Holmes Murphy | Dui Nec Tempus Inc. | 12:10 Oct 25, 15 | Sun, April 26, 2015 |
Blaine Valentine | Proin Institute | 04:10 Oct 16, 14 | Mon, March 30, 2015 |
Lionel Pacheco | Dolor Company | 07:03 Mar 18, 14 | Sat, May 24, 2014 |
Keefe Fletcher | A Mi Fringilla Industries | 03:09 Sep 25, 15 | Thu, October 22, 2015 |
Slade Rojas | Sodales Nisi Magna PC | 08:09 Sep 1, 15 | Wed, June 11, 2014 |
Vanna Kirkland | Tempus Inc. | 03:02 Feb 14, 15 | Wed, December 9, 2015 |
Cameron Peters | Lobortis Tellus Justo Limited | 06:02 Feb 9, 15 | Fri, January 2, 2015 |
Reed Freeman | Augue Sed Molestie LLP | 01:09 Sep 24, 15 | Sun, July 19, 2015 |
Florence Burgess | Aliquam Auctor Velit Incorporated | 05:04 Apr 20, 14 | Mon, September 8, 2014 |
- Javascript
- HTML
- CSS
- Ajax
- Server-side script
- Comments
The Javascript shown below is used to initialise the table shown in this example:
DataTable.datetime('EEE, MMMM d, yyyy');
DataTable.datetime('HH:mm MMM d, yy');
$('#example').DataTable({
layout: {
topStart: 'searchBuilder'
}
});
DataTable.datetime('EEE, MMMM d, yyyy');
DataTable.datetime('HH:mm MMM d, yy');
new DataTable('#example', {
layout: {
topStart: 'searchBuilder'
}
});
In addition to the above code, the following Javascript library files are loaded for use in this example:
The HTML shown below is the raw HTML table element, before it has been enhanced by DataTables:
This example uses a little bit of additional CSS beyond what is loaded from the library files (below), in order to correctly display the table. The additional CSS used is shown below:
The following CSS library files are loaded for use in this example to provide the styling of the table:
This table loads data by Ajax. The latest data that has been loaded is shown below. This data will update automatically as any additional data is loaded.
The script used to perform the server-side processing for this table is shown below. Please note that this is just an example script using PHP. Server-side processing scripts can be written in any language, using the protocol described in the DataTables documentation.
Other examples
Initialisation and options
- Basic Initialisation
- API Initialisation
- Button Initialisation
- SearchBuilder Configuration using Buttons
- Formatted Numbers
- Dates - auto locale formatting
- Formatted dates with Moment.js
- Formatted dates with Luxon
- Default Logic
- Restrict Filtering to Certain Columns
- Limit Sub-Group Depth
- Predefined Search
- Interaction with Empty Cells
- Force Search on Enter
- HTML Format
- Interaction with Rendered Cells
- Unknown Column Type
- Search on button