Help with expression start along with end

AppSheet AppSheet Q&A
1

schema is 'customer" [from date] ,[to date] are column in customer schema,

workflow run from customer schema. where the virtual column is [related sales order]

how to get [related sales order] with “start expression” and two conditions where order [ date] is more than [from date] and less than [to date]

for customer statements of between two dates.

2

Like this?

<<Start: SELECT([Related Sales Orders][key-column], AND(([date] >= [_THISROW].[from date]), ([date] <= [_THISROW].[to date])))>>

Replace key-column with the name of the key column in the table referenced by Related Sales Orders.

1 Like
3

will try it I already tried the same expression but maybe there was something my mistake.

4

Steve:

`<

lots a thanx steve its work perfectly…so happy…

1 Like