Forum Discussion

DjDon's avatar
DjDon
Frequent Visitor
5 years ago

Days between dates with nulls and blanks

Hello all, I have a table with three columns:  Seniority date, Hire date and data date.   I'd like to calculate the days/years between Seniority date and data date, however, the Seniority date col...
Days
DjDon's avatar
DjDon
Frequent Visitor
5 years ago

Appreciate the response, however, I still get the same error.  I did try to rewrite the code but now am getting a "Token Then expected" error ar runtime:

 

if [Seniority Date] <> null || [Seniority Date] <> ""
then
([data date]-[Seniority Date])/365.25
else if [Hire Date] <> null || [Hire Date] <> ""
then
([data date]-[Hire Date])/365.25
else
blank()