Hello Need help with selecting time in sql query

(0) Share

Report

Posted on by Abdulazizhalawa

am trying to send a daily email for VALUES Exceeded tolerance

but for some reason i cant use variables inside sql query in power automate

this how am creating the variable

this how am using it

a sql command that works fine

SELECT * FROM clParameterValues
WHERE Reasons <> 'did not exceeded tolerance'
AND submit_date >= '2023-09-04 15:00:00.000'
AND submit_date <= '2023-09-04 23:00:00.000';

I need to know the the time because am sending email per shift

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

SamLed 2,338 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi,

Your expressions should look like this:

StartDate: formatDateTime(utcNow(), 'yyyy-MM-dd 15:00:00.000')
EndDate: formatDateTime(utcNow(), 'yyyy-MM-dd 23:00:00.000')

If you can't use variables, have you considered using compose instead?
______________________________________________________________
If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

Was this reply helpful? Yes No
Abdulazizhalawa 67 on at

Like (0)

Report
Copy link

Link copied!

yes I have and both dont work further information submit_date column is datetime type and start and end time variables are String

Was this reply helpful? Yes No
Chriddle 8,513 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!
You are doing the string concatination wrong. "&" does not work.

You can check the concat function or just use an according format string.

(Since the date functions accept a format string, you don't have to use formatDateTime):

utcNow('yyyy-MM-dd 23:00:00.000')

returns

'2023-09-05 23:00:00.000'

Was this reply helpful? Yes No