1 Reply Latest reply on Jun 12, 2013 6:37 AM by Brad Llewellyn

    Creating Dates from data elements

    Martin Vrieze

      I have the following data elements...

      FISC_YR

      FISC_MO

      ...representing fiscal year and month numbers.

       

      Using each of the following variants of the DATE() function yields the null value...

       

      DATE("[FISC_MO]/1/[FISC_YR]")
      DATE("str([FISC_MO])/1/str([FISC_YR])")

      DATE("float([FISC_MO])/1/float([FISC_YR])")

      DATE("int([FISC_MO])/1/int([FISC_YR])")

      DATE("str([FISC_MO]/1/[FISC_YR])")

       

      What is the correctly formatted variation that will yield a valid date that can be dropped into a visualization?