You can construct the Data type of a column according to your requirements by hovering over the column or from the “Table Configuration” settings of the specific column. The “Date Field” is for columns with dates with customized date formats.
You can decide the data type right from the start when you add a column to the table. From your dashboard, go to the Ninja Tables plugin → Tables (the table where you want to add Column) → Add Column.
- A pop-up form will appear, and you will see the available Data Type here. You can choose from the various data type listed in the below screenshot.
Date Field #
This data type is used to add a date in the input field. You can customize the date format and change the format anytime.
- Now a new column with data type has been added to the table. To see this data type, click on the Edit icon (right side of the table column). A window will appear then. See the below screenshot –
Date Format (Standard) #
It indicates the pattern of the date value. The date field mainly includes 8 formats.
- Another key consideration is that no matter what Date Format you select in your Column settings, your column values must be in the same format; otherwise, they will not work.
- For example, see the below screenshot –
- This is how your column value needs to be in the same format.
Date Format (Custom) #
There is also a Date format option where a custom date can also be added if the default options do not meet your needs. You can put your custom date as per your requirements. Custom dates need to be in moment.js supported format.
Custom Date Format is a Pro feature!
Show Time #
If you Enable this option, then the time picker will be available. It includes mainly 12-time formats.
First Day #
It shows the first day of the week. For instance, Sunday, Monday, etc.
Note that the Date Field data type is HTML supported.
- Now, go to the Preview of the table, and you will see the Date Field data type has supported HTML.
This is how you can add a Date Field data type in your column easily!
