Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

how to do incremental refresh for date

How to perform an incremental refresh for a date column in the yyyy/mm/dd format?

I have a column in my dataset that contains dates in the format yyyy/mm/dd. I want to apply an incremental refresh specifically to this column. However, I am currently unable to do so as my current approach only supports the date/time format.

 

Please suggest some way to resolve ir

Need Help

4 Replies

  • cassidy's avatar
    cassidy
    Power Participant
    3 years ago

    You'll need to add a step in query editor converting the Date to Date/Time.  Incremental Refresh will recognize the column then.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      cassidy  please help with the step.

      • cassidy's avatar
        cassidy
        Power Participant
        3 years ago

        In query editor, you can click on the Type icon of the Column header and switch it to a variety of Types, one being Date/Time