Is it possible to add a date column within a table ?

  • Profile Image
    FMMS_Changemaker
    Asked on March 06, 2020 at 09:51 AM

    Is it possible to add a date column within a table i.e the person inputting the data has the option to select a date, or input the date in a set format (same as if they the field was just a date field) 

  • Profile Image
    Richie_P
    Answered on March 06, 2020 at 11:05 AM

    May we know if you're referring to the input table?

    Currently,it is not possible to add a datepicker or calendar field in the input table.

    Here is a screenshot of the available fields you can add in the input table.

    Hope this information helps.

  • Profile Image
    FMMS_Changemaker
    Answered on March 06, 2020 at 12:51 PM
    Thanks, I have created a table and used a textbox field for the inputter to
    add a date, however the field records as text not a number and therefore
    when I tried to add a formula that works out the time between two dates
    (one being a date picker field and the other the text field on a table) it
    records an *Error* - "function value 2 expects a value. But the "21/9/17"
    is a text can cannot be coerced to a number"
    43,870.00
    #VALUE!
    ...
  • Profile Image
    JohnRex
    Answered on March 06, 2020 at 02:24 PM

    You were right. The dates entered in a textbox inside the Input Table field is treated as TEXTS. Note that there is no option to add a date picker field in the Input Table, and calculating time and date differences will only work with Date Picker fields.

    I suggest creating separate Date Picker fields to be able to capture the dates that will be used in a calculation.