0

How do I set a period date to search in Jet Reporting?

Hi,

1. May I ask how do I set a period date to search in Jet Reporting?

For example, I would like to set it in a week this way:

Option Posting Period "11102021..17022021"

2. I understand that if I want to pull out the day before yesterday, I can do this base on the location of the item.

=$C$2-7&".."&$C$2

Where C is the column and 2 is the row, -7 is to calculate the first day of the week.

Thank you!

 

3 comments

Please sign in to leave a comment.