Issue in Sql query to select from a Range

Hi, Im trying to select a range of values from a table using SQL (Using Between And) there is no error in query but also its not returning anything. Please help.
SamExcel.xls (27.5 KB) Example.xaml (19.0 KB)

Hi @Muthulakshmi_Thangamuthu ,

The and [Action taken on] between 20/02/2021 AND 20/03/2021 doesn’t seem to be written quite right.

Based on this Topic I’ve changed a little bit your workflow and it worked

This is how you’ve to amend your workflow to give the right results:

Hope this helps!
Best regards,
Marius

1 Like