Trying to build a spreadsheet that will filter a GI brought into it. I have Cell B2 as a financal period, then I populate cells B2 and B3 with the FINANCIALPERIODSTARTDATE and FINANCIALPERIODENDDATE.
Then I have my GIFILTER in cell A5. The formula is =GIFILTER("qa","Deferred Rev TDC Data","Date",">=B2","Date","<=B3"). But the return value of Cell A5 is
Date ge B2 and Date le B3 I was expecting Date ge 10/1/2024 and Date le 10/31/2024.
0 Votes
Trying to build a spreadsheet that will filter a GI brought into it. I have Cell B2 as a financal period, then I populate cells B2 and B3 with the FINANCIALPERIODSTARTDATE and FINANCIALPERIODENDDATE.
Then I have my GIFILTER in cell A5. The formula is =GIFILTER("qa","Deferred Rev TDC Data","Date",">=B2","Date","<=B3"). But the return value of Cell A5 is
I was expecting Date ge 10/1/2024 and Date le 10/31/2024.
Not sure where I went wrong.
0 Votes
Harry Lewis posted 15 days ago Admin Best Answer
Hi Claude -
Try this: =GIFILTER("qa","Deferred Rev TDC Data","Date",">="&B2,"Date","<="&B3)
0 Votes
2 Comments
Claude Matherne posted 15 days ago
Sweet. That worked. Thanks
0 Votes
Harry Lewis posted 15 days ago Admin Answer
Hi Claude -
Try this: =GIFILTER("qa","Deferred Rev TDC Data","Date",">="&B2,"Date","<="&B3)
0 Votes
Login or Sign up to post a comment