How to create a inflow outflow table where we need to use 2 different date fields

Question

I am looking for Records either opened or closed current month. in Excel or quickbase, it is only allowing me to use 1 date field for the red, but i need to use both start and end date for the data flow. raw data on the left and looking to create the right. if i can figure out the table, i can then make inflow outflow graph

Filter for either created current month or has end date of current month [done]
not sure how to pivot for 1 date column when i need to pull from 2 date fields. help needed here

score 1 · Accepted Answer · answered Dec 20 '21 at 17:41

1

I Quickbase you can evaluate multiple fields in a filter like this:

answered Dec 20 '21 at 17:41

Erich Wehrmann

464
2
11

score 0 · Answer 2 · edited Dec 18 '21 at 01:02

0

=IF(C2="closed",D2,A2)

edited Dec 18 '21 at 01:02

Jeremy Caney

7,102
69
48
77

answered Dec 17 '21 at 17:14

msulol

67
6

How to create a inflow outflow table where we need to use 2 different date fields

2 Answers2