I currently have three fields for entering the three parts of the date; 'day' 'month' & 'year' in the following format 31 January 2013.
These three fields are then compiled into a field titled: expiry date text, which then allows the step below to change the date into the format 31/01/2013.
the field called called 'expiry_date' converts the expiry date text into the format 31/01/2013. The calculation in this field is as follows:
I would like to add to this calculation so if the user enters N/A into the 'day' 'month' or 'year' fields it will make the expiry_date field display "N/A"
Any help would be appreciated.