Duration Date/Time and Dates
I am trying to figure out a formula for duration. my problem is that one set of date is Date/Time, while the other is only Date.
QC Date - Date/Time Start Date - Date The QC Date pulls from a r...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThis will give you a Duration result
ToDate([QC DATE CREATED])-[DESIGN START DATE])
Personally I find duration fields confusing to work with. I prefer to have a numeric field representing the # of days when dealing with short term time ranges.
This would be a numeric field​
ToDays(ToDate([QC DATE CREATED])-[DESIGN START DATE]))
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
ToDate([QC DATE CREATED])-[DESIGN START DATE])
Personally I find duration fields confusing to work with. I prefer to have a numeric field representing the # of days when dealing with short term time ranges.
This would be a numeric field​
ToDays(ToDate([QC DATE CREATED])-[DESIGN START DATE]))
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------