Operators / Expressions

[chriss_ko]

Please i need help,

I have my database, and the is two columns one has last renewal date and the other has expiry date, i want to make another column that will either display Active or Deactive user by looking at the expiry date column. on that column i want when the column (expiry _date) is less than current date then to display ACTIVE but when current date is greater than expiry date it should display DEACTIVE.

I have created a query but failed to wright expression. please help me how do i write such expressions on a query.

 

[arnelgp]

Status: IIF(Date() > [Expiry Date], "DEACTIVE", "ACTIVE")

 

[chriss_ko]

Status: IIF(Date() > [Expiry Date], "DEACTIVE", "ACTIVE")

Thank you very much it has worked.