Forum Discussion

Maria_Del_Carme's avatar
Maria_Del_Carme
Qrew Member
2 years ago

Update Data Fields

it is possible to change the type of data to a field of a table that is generated automatically by QuickBase?

------------------------------
Maria Del Carmen Ortiz Garcia
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    2 years ago
    Sorry but I am not understanding your question. Can you give an example of what you mean? When you say a field that is generated automatically by QuickBase do you mean the five built-in fields for record owner and last modified by etc?

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • Maria_Del_Carme's avatar
      Maria_Del_Carme
      Qrew Member
      2 years ago
      That's right, I need to change the data type of the Date Created and Date Modified fields from Date/Time to only Date

      ------------------------------
      Maria Del Carmen Ortiz Garcia
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        2 years ago
        No, you cannot change those built-in fields but you really have no problem. If you simply don't want to see the time displayed you can change the format of those fields to not display the time but probably a better idea is to leave those in their native format and just create a new field formula date called perhaps  [Date Created.] (ie, with an extra dot) with a formula of ToDate([Date Created]).

        Then just use the "dot" version of the field for when you only want to use the date.

        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------