Named Query Test values datetime

I am trying to test this query under Named Queries, I need to pass the datetime as parameter , I want to type it there and also pass the “now” using a function if possibly, help welcome.

image

If you type a date in the normal format of 2022-08-26 and press enter then ignition should format for you (in the newer versions at least)

that worked, thanks

1 Like