Reading data from MSSQL for a date range using DatePicker

General
1

Hi, Im having problem when reading data from MSSQL. I can't get the SQL statement right and get this error always. I did try to change the format type to the same as MSSQL, but it didn't work.

image
image1285Ă—677 27.5 KB

image
image
image960Ă—572 28.2 KB

this is my flow:
flows.json (7.1 KB)

2

You have created an ISO8601 timestamp format which is incorrect for MSSQL. Correct format for MSSQL is 'YYYY-MM-DD HH:MM:SS', e.g. '2022-12-09 12:34:56'.

1 Like
3

I did try, but still get the same error

image
image1658Ă—826 73.1 KB

4

No you haven't - check that date string again, it is not 'YYYY-MM-DD HH:MM:SS', it is 'YYYY-MM-D H:M:S'

1 Like
5

I try again, and this is the result

image
image1706Ă—843 68.2 KB

6

I'm wrong in using flow variable, it works now with your suggest, thank you!

7

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.