Need to calculate # of days between Date Created (date/time field) and a Date field titled ""Date of Contact
Need to calculate # of days between Date Created (date/time field) and a Date field titled "Date of Contact"
Forum Discussion
3 Replies
- ToDate([Date Created]) - [Date of Contact]
- Thanks, this works but looks like I need the reverse - the Date of Contact - Date Created. Gives me an error
- Did you swap them exactly as you see them while also keeping the ToDate function attached? If your Date of Contact field is a date/time field then it will need to be wrapped in ToDate as well to make sure it is only a date.
You did this?
[Date of Contact] - ToDate([Date Created])
