I am trying to execute a very simple SQL statement from PowerAutomate desktop version with one hiccup. The DATE_FORMAT clause that I use for MySQL contains the % sign so that it is formatted correctly. When I put this into PowerAutomate though it doesn't like the % signs. All I want is to take the date from that column (custom_200000004) and convert the date to be mmddyyyy (01011990) no spaces, dashes, or slashes. Is there a work around for this??
Try escaping % by replacing with %% (double) to avoid it being read as variable. You may try replacing double quotes with single quote as shown in the below example:
Here is an example of MSSQL query:
If this helps & solves your problem, please remember to like and accept my solution as it will help others in the future.
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
2
Share
Report
All responses (
Answers (
