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 this value to date values.
This value should return in dutch culture 03-10-2017 for 3 october 2017.
This works well in the desktop version but after publishing the report and refreshing it by the on premis gateway the datevalues are shown incorrect. I get the result 10-03-2017 instead.
I hope someone has a sollution.
Thanx
4 Replies
Arnoh wrote:
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 this value to date values.
This value should return in dutch culture 03-10-2017 for 3 october 2017.
This works well in the desktop version but after publishing the report and refreshing it by the on premis gateway the datevalues are shown incorrect. I get the result 10-03-2017 instead.
I hope someone has a sollution.
Thanx
Have you format the date in Power BI desktop? I'm not able to reproduce that issue.
Hi thanx for your reaction,
Yes i formated the date in the desktop.
I have some screen shots addes.
the sql script for the sybase database
the date formatthe result after a refreshing with on premis gateway. in te first date colum the day and month are for some records changed
In the snapshot, I see FAC_DATUM shows as the expected "DD-MM-YY" which is different from the description in your original post.
