Forum Discussion
date format
Hello, I have the following issue: i am using the desktop version and connecting to a sybase database. In the database the date values are stored as text fields like: '20171003' I convert ...
In the snapshot, I see FAC_DATUM shows as the expected "DD-MM-YY" which is different from the description in your original post.
In the last snapshot you see in the kolom factuur datum dates with value 10-02-17.
In the sybase database these value is stored as ‘20171002’ as text.
In the Powerbi Desktop the date returns as 02-10-17 which is should be (dd-mm-yy).
After publishing the values seems to be ok and are also shown as 02-10-17.
When the data is refreshed the values show 10-02-17.
Only dates where month an day are able to switch are shown incorrect.
So date 23-02-2017 (23 february 2017) will go correct after refreshing.