how to do incremental refresh for date

[Anonymous]

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

[cassidy]

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

[Anonymous]

@cassidy  please help with the step.

[cassidy]

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]

My data dint got refreshed