Forum Discussion

KathyBenjamin's avatar
KathyBenjamin
Qrew Trainee
2 months ago

Date/Time format

Is it possible in quickbase to have a field display date/time like this - 02/20/2025  10:24:53 AM?  The closes I can get is 2/20/2025 10:24 and it cuts off the seconds and AM/PM.

formulas
  • DonLarson's avatar
    DonLarson
    Qrew Elite
    2 months ago

    If this is solely a UI issue, you can create a Formula Text field that will display that.  Your Users will see it they way you want.   

    If you are trying to export that data, it will not be a Date/Time field which would cause you issues in other systems.

    • KathyBenjamin's avatar
      KathyBenjamin
      Qrew Trainee
      2 months ago

      Not exporting, its just a display that i need.  Do you know the formula to use?

      • PrashantMaheshw's avatar
        PrashantMaheshw
        Qrew Captain
        2 months ago

        I am able to see the time as 02/20/2025 10:24 AM if you enable SHOW TIME in field settings . 

        To show Milliseconds , the only thing which works is having a duration field. If you do decide to convert your time to  

        var duration xyz = Hours(3)+Minutes(20)+Seconds(30);
ToFormattedText($xyz,"HHMMSS")

        Your bigger problem is storing the data , if you store your field as date time it, will only be stored at YYYY-MM-DD HH:MM AM/PM , there is no milliseconds. But we can still show it as 00. Assuming you calculate all timings from midnight, if my DateTime Field Is [All]. This below formula will give you output to 2025-03-13 2:45:00 but it's always 00

        var datetime abc = ToTimestamp(ToDate([All]),ToTimeOfDay("00:00"));
var duration xyz = [All]-$abc;

ToFormattedText(ToDate([All]),"YYYYMMDD")&" "&ToFormattedText($xyz,"HHMMSS")

        Which means your only option is capture Date then capture Time of day separately . Making sense?