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

[Anonymous]

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..

[VahidDM]

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✌️!!

[Anonymous]

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

[Anonymous]

date(2021, 9, 3)

[Anonymous]

Not working

[Anonymous]

@Fowmy