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.
Forum Discussion
Not exporting, its just a display that i need. Do you know the formula to use?
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?