The Date Field can be used to store dates, date ranges and a date and time combination. The Text Field is most commonly used to store:
Note: You can visualize records with a set date in your calendar.
Learn how you can add a new Field in Fusioo. Here are some of the Text Field’s additional options:
Default Value | A Default Date is added automatically when creating a new record.
Note: You can set the default date in the past by entering a negative number. |
Date Type |
|
Display count from today | When ticked, the date will be displayed as a count from the current date (now). For example, 5 days ago OR in 16 days. |
You can choose your preferred date format when manually entering dates. This is done from the Profile Page.
Today's date is taken as default when typing a date. This means you can type only part of the date and the rest will be added automatically. For example, assuming today is 30th May 2019:
You enter | Date input format | Result |
5 | Day > Month > Year | 5th May 2019 |
25 10 | Day > Month > Year | 25th October 2019 |
11 | Month > Day > Year | 30th November 2019 |
11 2 | Month > Day > Year | 2nd November 2019 |
2020 | Year > Month > Day | 30th May 2020 |
2020 7 | Year > Month > Day | 30th July 2020 |
Note: You can use different separators between day/month/year. 5.10.2019, 5-10-2019, 5/10/2019 and 5 10 2019 will all result in 5th October 2019.
Can be used for searching? | No |
Can be used to sort records? | Yes |
Can be used as a Badge Heading? | No |
Can be used for grouping in the Kanban Board? | Yes |
Filtering options |
|
Type above and the results will be displayed here.