Forum Discussion
Region date query problems - Desktop vs. Dataflow - Cannot convert value #date to type Text
Hi, Trying to turn a query I have on desktop into a dataflow. The main issue I am having now is that my date formats are dd/mm/yyyy which on my desktop query doesn't cause any problems. When I re...
What you need to do is use the change type with locale, this can be done when you right click on the column go to the change type drop down and click with locale.
I do not know of a way to do locale type changes using the "type date" synatx.
I had never spotted that before! Brilliant stuff I'll give that a go.
