How can I display different message based user input date? I have table field which holds date named completiondate. the field contains a date, null, or default date 1900:00:00:00. I want to give messaage 'Available' if user input date is greater than the completion date or null or default date and 'not available' if user input date is less than the completion date. How can I do it using case when statement?