0 Use getDate() to get the current date
Example
Select getdAte()
Use DatePart to extract month and year
example
select DAtePart(mm,getDate())
Use Case statement as
Select case when a=1 and b=1 then cast(DateStoredInDatabase as varchar) else
'exp date' end from MyTable
Check this is correct answer if it helped.