Duration Date/Time and Dates

Question

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/TimeStart Date - DateThe QC Date pulls from a relationship, so I don't think I can simply change the QC Date to "date" only because of the relationship.
However, what I am trying to do is determine only the number of days between the two and exclude the "time" portion, if possible.
I thought i was close with this formula, but it does not like the subtraction.DAYOFYEAR(TODATE([QC DATE CREATED]))-[DESIGN START DATE])
All i need it to do is pull the date and ignore the time stamp - QC date 11/22 - start date 11/20 = 2 days. Is this possible? I looked at other formula functions as well, but to no luck so far.Thanks!------------------------------Bret Osborne------------------------------

MarkShnierYou · Answer

This will  give you a Duration resultToDate([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------------------------------

Sign up

Login to the community