my issue was formula was date not date/time, duh