cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DSFlemming
Helper II
Helper II

ODATA date filter where SQL column is string format

Hi everyone

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

 

DSFlemming_0-1636090248667.png

 

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.

1 ACCEPTED SOLUTION

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

Hi @DSFlemming ,

 

You could use Filter action.

vxiaochenmsft_0-1636538608376.png

 

formatDateTime(item()?['StartDate'],'yyyy-MM-dd')
adddays(utcNow(),7,'yyyy-MM-dd'
 
Best Regards,
Wearsky

View solution in original post

2 REPLIES 2
v-xiaochen-msft
Community Support
Community Support

Hi @DSFlemming ,

 

You could use Filter action.

vxiaochenmsft_0-1636538608376.png

 

formatDateTime(item()?['StartDate'],'yyyy-MM-dd')
adddays(utcNow(),7,'yyyy-MM-dd'
 
Best Regards,
Wearsky
DSFlemming
Helper II
Helper II

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

Regards, Dale

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (2,904)