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.
Any solutions appreciated 🙂 Thanks


Report
All responses (
Answers (