date format

[Arnoh]

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

[Eric_Zhang]

---

@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

---

@Arnoh

Have you format the date in Power BI desktop? I'm not able to reproduce that issue.

[Arnoh]

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

[Eric_Zhang]

@Arnoh

In the snapshot, I see FAC_DATUM shows as  the expected "DD-MM-YY" which is different from the description in your original post.

[Arnoh]

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.