Forum Discussion

Arnoh's avatar
Arnoh
Helper III
8 years ago

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 ...
Need Help
Arnoh's avatar
Arnoh
Helper III
8 years ago

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's avatar
Eric_Zhang
Microsoft Employee
8 years ago

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's avatar
    Arnoh
    Helper III
    8 years ago

    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.