0

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

Josh

October 22, 2021 05:04

None

Follow

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!

 

• Facebook
• Twitter
• LinkedIn

3 comments

• 1
  
  Steve Jenkins October 22, 2021 16:21

  Assuming that C2 is in a date format (10/12/2021), I do the following:

  =TEXT($C$2-7,"mmddyyyy")&".."&TEXT($C$2,"mmddyyyy")

• 0
  
  Josh October 25, 2021 13:33

  Hi Steve,

  Thanks for your suggestions. May I ask what does the "TEXT" means ? What do I put in the TEXT?

  Thank you

• 1
  
  Steve Jenkins October 25, 2021 13:45

  The TEXT function lets you change the way a number appears by applying formatting to it with format codes.

  =TEXT(Value you want to format, "Format code you want to apply")

  See https://support.microsoft.com/en-us/office/text-function-20d5ac4d-7b94-49fd-bb38-93d29371225c for more info.