nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to have the inputs for StartDate and EndDate in SQL?

tanthiamhuat

I have Report Parameters (StartDate and EndDate), and I want these 2 inputs inside the SQL. I tried below, but does not work.select SYSTEMTYPE_ABC, TIME_STEP, TIME_SYSTEM, LASTUPDATEfrom table_XYZwhere (SYSTEMTYPE_ABC like ?) and (LASTUPDATE BETWEEN like ? AND like ?)What the correct syntax?thanks.

Find more posts tagged with

Comments

kclark

After writing that sql statement did you link the parameters in the parameter tab of the query builder UI?

tanthiamhuat

yes, there are 3 input parameters linked, as seen in the printscreens. would you able to join.me, so that I can share the screen to show you?

Hans_vd

Hi Tanthiamhuat, You need to remove the "like" keywords when comparing to dates.So change<pre class="_prettyXprint">and (LASTUPDATE BETWEEN like ? AND like ?)</pre>[color=rgb(40,40,40);font-family:helvetica, arial, sans-serif;]into[/color]<pre class="_prettyXprint">and (LASTUPDATE BETWEEN ? AND ?)</pre>Hope it helpsHans