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.
|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|
Type above and the results will be displayed here.