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!