I am trying to make it so that if the value that the first part of the expression is less than 1, then a message "subscription ended" comes up, however this isnt working any suggestions as to why wud be gr8!
DateDiff("y",[Magazine Records]![Current Date],[Magazine Records]![Date Subscritpion Ends]) And IIf([days left]<1,"subscription ended","«falsepart»")
DateDiff("y",[Magazine Records]![Current Date],[Magazine Records]![Date Subscritpion Ends]) And IIf([days left]<1,"subscription ended","«falsepart»")