9 Replies Latest reply on Sep 18, 2013 12:39 PM by Alexander Severinsen

    How to get data from integer fields month and year

    Alexander Severinsen

      I´ve got two integer fields with month 1-12 and year (four digits). I am trying to format that to a date field. I tried a calculated field:

       

      DATE(STR( [year] )+ '.1.'+STR([month]) )

       

      That seemed to work, but then I notice that day is month and month is day. I thought that that just changing into DATE(STR( [year] )+STR([month])+ '.1.' ) would help but that messes everything up... I tried to change workbook local, but that did not help either. Any suggestions?

       

      Thanks.

       

      Kind regards

      Alexander