Forum Discussion
jeremypmr
7 years agoFrequent Visitor
Sum if between dates
We have a table with unique rows containing: File Number, Lock Start Date, Funded Date, Loan Amount. We are trying to create a visual that only shows the total count of how many files with the su...
v-juanli-msft
7 years agoCommunity Support
Hi jeremypmr
Since we are in different timezone, could you show example of your week start date and end date?
For example, in my test, week begins from Monday and ends at Sunday
Best Regards
Maggie
jeremypmr
7 years agoFrequent Visitor
I haven't fully built that part yet. This is the path I was going down but I like yours better:)
Week start would be Monday like you have it:) Thanks so much!