Power Platform Community Forum Thread Details

SQL Get Rows Filter Query with Date

Hi,

I know a few people had this issue with filtering to match the date, and the solution was to but an expression on the right hand side of the filter; however, I was wondering if I could add another expression onto the existing variable on the left hand side.

In my case, NextMetadataReviewDate, could I put another expression to format it?
(the expression on the right is: formatDateTime(utcNow(),'yyyy-MM-dd')

Expression altogether is NextMetadataReviewDate eq 'formatDateTime(utcNow(),'yyyy-MM-dd')'

Right now that expression to match date isn't working... But I am thinking it may have something to do with my NextMetadataReviewDate within SQL format is different? that's why I want to try a expression similar to formatDateTime(utcNow(),'yyyy-MM-dd') but instead of UTCNOW, It should be NextMetadataReviewDate, but I don't know the proper syntax or if it's possible to reference your own variable in the same box.