AnsweredAssumed Answered

Date N/A

Question asked by hrcap on Sep 5, 2013
Latest reply on Sep 6, 2013 by philmodjunk

Title

Date N/A

Post

     Afternoon All

      

     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:

      

      
     Let ( Month = Ceiling ( Position ( "JanFebMarAprMayJunJulAugSepOctNovDec" ; Left ( expiry Date Text ; 3 ) ; 1 ; 1 ) / 3 ) ;
             Date ( Month ; MiddleWords ( expiry Date Text ; 2 ; 1 ) ; RightWords ( expiry Date Text ; 1 ) )
           )

      

     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.

      

     Cheers

      

     Hadleigh

Outcomes