Two date fields to get orders

Ask for Help
1

Hi

I have two date fields one is date ordered field and another one is future date,both I’m selecting manually.

Now I need to get orders within this date in an line list.

How to do this?

2

Create an if-then-else column:

  • If order date is before start date, then false
  • If order date is after end date, then false
  • Else true

Any rows that have true in that column will have order dates in between your start and end dates.

2 Likes
3

Hi

It’s not working.

4

Screenshot please.

5

Hi,Please check

doubt1
doubt11686×417 92.9 KB

doubt2
doubt21591×858 110 KB

doubt3.PNG
doubt3.PNG1639×687 120 KB

6

When I change the date as 28,it still showing the orders.

7

In your 3rd screenshot, you have two date picker components, but I can’t see where those values are being written to. Essentially what you need to do is write those values to two user specific columns, and then use two single value columns to apply the selected dates to all rows. You can then use the if-then-else column as I described earlier, comparing your order date to the two single value columns.

8

Yes ,I have created now but not working.whether the two date picker needs to be user specific?

9

doubt4
doubt41700×511 91.4 KB

doubt5
doubt51721×857 109 KB

Am i doing anything wrong in ite column?

10

Now the table updates correctly.Thanks

11

It looks okay.
In your earlier screen shot, you had 2 records on the 20th, 1 on the 21st and 1 on the 28th.
None of those are between the 22nd and 27th, so what you see is expected.

What happens if you change your start date to the 20th?

12

But my inline list displays all 4 orders instead of two.

13

Sorry i didn’t filter it.now I did.thank you.

16

Hi Darren,

The one order on 30 th not showing but it should show.

d6
d61766×431 90.4 KB

d7
d71702×837 105 KB

17

There is probably a time component to the timestamp value that puts it after the end date. Does it return true if you select the 31st as the end date?

18

yes.its returning true.any solution?

19

Assuming that you want the Start and End dates to be inclusive, then you could probably just extend the if-then-else. Try the following:

  • If Order Date is within Start Date, then true
  • If Order Date is within End Date, then true
  • If Order Date is before Start Date, then false
  • If Order Date is after End Date, then false
  • Else true
2 Likes
20

working perfectly as of now.will double check once tested the app completely.Many Thanks.

21

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