Nested If else statement help

[Anonymous]

Hi, I am trying to add a custom column and written the following code, but its giving me error(The pic of the table is also attached):-

if [Date] < DateTime.Date(DateTime.LocalNow()) and [Status]="3" then "Completed"
else if [Date] > DateTime.Date(DateTime.LocalNow()) then "Not Overdue"
else if [Date]= "null" or [Status] = "0" then "Overdue"
else [Date] < DateTime.Date(DateTime.LocalNow()) and [Status] = "1" or [Status] = "2" then "Overdue"

I get the error Token eof expected. Would appreciate some help!

 

[Gordonlilj · Accepted solution]

Hi,

Try something like this

if [Date] < DateTime.Date(DateTime.LocalNow()) and [Status]="3" then "Completed"
else if [Date] > DateTime.Date(DateTime.LocalNow()) then "Not Overdue"
else if [Date]= "null" or [Status] = "0" then "Overdue"
else if [Date] < DateTime.Date(DateTime.LocalNow()) and [Status] = "1" or [Status] = "2" then "Overdue" else ""