ODATA date filter where SQL column is string format

[DSFlemming]

Hi everyone

I'm using Get Rows v2 on a table where the 'StartDate' column is varchar and formatted as yyyy-MM-dd.

I need to filter the upcomnig week's data and I expect I'll be working with someting like StartDate le adddays(utcNow(),7,'yyyy-MM-dd') but I'm not sure how to modify the table's 'StartDate' column in the ODATA query to make it workable.

Any advice greatly appreciated.

[v-xiaochen-msft · Accepted solution]

Hi @DSFlemming ,

You could use Filter action.

formatDateTime(item()?['StartDate'],'yyyy-MM-dd')

adddays(utcNow(),7,'yyyy-MM-dd') 

Best Regards,

Wearsky

[DSFlemming]

That's great Wearsky. Just what I needed. Thanks for the tip.

Regards, Dale