Discussions

 View Only
  • 1.  Update Data Fields

    Posted 11-09-2022 12:28
    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
    ------------------------------


  • 2.  RE: Update Data Fields

    Posted 11-09-2022 12:36
    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
    ------------------------------



  • 3.  RE: Update Data Fields

    Posted 11-09-2022 12:41
    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
    ------------------------------



  • 4.  RE: Update Data Fields

    Posted 11-09-2022 12:44
    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
    ------------------------------



  • 5.  RE: Update Data Fields

    Posted 11-09-2022 14:16
    Thank you really helped me a lot...

    ------------------------------
    Maria Del Carmen Ortiz Garcia
    ------------------------------