Format date function does not support in SQL Direct Query

[Shree_185]

Hi everyone, In the last line, the format function does not support it, what is the alternative solution for this?

[v-stephen-msft]

Hi @Shree_185 ,

Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your problem.

Best Regards,
Stephen Tao

[amitchandak]

@Shree_185 , are you creating that a new column? , then there limit on functions supported.

You can use meausre