Hi. I’m a Community Edition user and I’m trying to calculate the interval between two DateTime (note: the interval is greater than 366 days), I’ve done the following:
- Assign variable StartDate_DateTime (type DateTime) to DateTime.ParseExact(Start_Date, “dd-MMM-yyyy”, CultureInfo.InvariantCulture) ==> Output is in “MM/dd/yyyy hh:mm:ss”. Same process repeated for EndDate_DateTime
- Assign variable TENURE (type Int64) to DateAndTime.DateDiff(DateInterval.Day; StartDate_DateTime, EndDate_DateTime) ==> Output is 0
I’ve also tried using cdate function on the StartDate_DateTime and EndDate_DateTime but it still returns 0.