3 Replies Latest reply on Sep 1, 2016 7:10 AM by kmakat

    Create date field from numbers with inconsistent entries

    kmakat

      Hello,

       

      I have to enter a date but for many records I just have information about the year or the year and month. There are possibly much more elegant solutions, but I designed three number fields, Day, Month and Year, to enter the available information and then also created a calculation field cDate (result text) that creates a date format 16/31/2016 (result text); on the layout the format is changed to 2016-08-31.

       

      While this works reasonably well for my single-user solution when I enter values for all three - day, month and year - it fails to evaluate if day or month is missing (result ?). I tried different conditional calculations of which the latest version is:

       

      If(IsEmpty ( DayOfDiagnosis );

      MonthOfDiagnosis & "/" & YearOfDiagnosis;

      If(IsEmpty (MonthOfDiagnosis); YearOfDiagnosis; 

      MonthOfDiagnosis & "/" & DayOfDiagnosis & "/" & YearOfDiagnosis))

       

      Any tips and suggestions are very welcome!

       

      Thank you,

      Kemal