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 s...
Need Help
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

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      My data dint got refreshed