Forum Discussion

patolattari's avatar
patolattari
Regular Visitor
8 years ago
Solved

Date problem

 

Hi guys, i'm kind of new with PBI and i need some help, importing from sharepoint, there's one column with dates, and even though it's OK on the source, (checked), PBI takes and shows it as the day before, Nov 29th instead of 30th. I tried changing the region but the error remains...

 

Any idea of what yould I do? if i can't fix it, hoy could I create a new column with the previous column date plus one day?

 

Thanks!

  • jthomson's avatar
    jthomson
    8 years ago

    Press new column, enter the existing column's name, type in +1...

5 Replies

  • patolattari's avatar
    patolattari
    Regular Visitor

    Hi guys, i'm kind of new with PBI and i need some help, importing from sharepoint, there's one column with dates, and even though it's OK on the source, (checked), PBI takes and shows it as the day before, Nov 29th instead of 30th. I tried changing the region but the error remains...

     

    Any idea of what yould I do? if i can't fix it, hoy could I create a new column with the previous column date plus one day?

     

    Thanks!

  • jthomson's avatar
    jthomson
    Solution Sage

    For the second question, having a calculated column reference the existing date column and adding 1 should be straightforward. Not sure why the first one would crop up - possibly it's some sort of time zone issue where it's interpreting the date as datetime and then shifting the time zone to UTC or something which affects the date as a result?

    • patolattari's avatar
      patolattari
      Regular Visitor

      Thanks for your response, could you tell me how to create that column?

      • jthomson's avatar
        jthomson
        Solution Sage

        Press new column, enter the existing column's name, type in +1...