Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Cannot construct data type time, some of the arguments have values which are not valid..

Hi Guys I am working on a Direct Query table date calculation.

 

The date calculation working fine on the import mode and not working on DQ mode. What is the reason for this and how to fix it.

Error Message : Cannot construct data type time, some of the arguments have values which are not valid..

 

 

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    date(2021, 9, 3)

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Not working

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Most likely because your column that you want to apply the "<=" operator to is not of type date/time whereas DATE(...) is.

  • VahidDM's avatar
    VahidDM
    Icon for Super User rankSuper User
    5 years ago

    Hi Anonymous 

     

    Which type of data do you have in the [DownTime_Start] column? Can you share a sample of your data here?

     

    Appreciate your Kudos✌️!!