3 Replies Latest reply on Mar 23, 2016 3:25 PM by Dan Cory

    Tableau Data Engine Error: 4: no such function (+ date datetime) for MAKEDATETIME function

    ALIABBAS PETIWALA

      getting following error for calculated field MAKEDATETIME([Date Of penalty],[TimeOfpenalty]) in tableu 9.2:

      Tableau Data Engine Error: 4: no such function (+ date datetime)

       

       

      query:

       

       

      (restrict

        (aggregate

          (project

            (table [TableauTemp].[Data_2013#csv])

            (

              ([qr:Calculation_903816214254735377:ok]

                (quarter

                  (+ [date_of_penalty]

                    (parsedate [time_of_penalty] "HHMM")

                    )

                  )

                )

              ([yr:Calculation_903816214254735377:ok]

                (year

                  (+ [date_of_penalty]

                    (parsedate [time_of_penalty] "HHMM")

                    )

                  )

                )

              )

            )

          (

            ([qr:Calculation_903816214254735377:ok] [qr:Calculation_903816214254735377:ok])

            ([yr:Calculation_903816214254735377:ok] [yr:Calculation_903816214254735377:ok])

            )

          ()

          )

        ([qr:Calculation_903816214254735377:ok] [yr:Calculation_903816214254735377:ok])

        )