# Custom Period - Previous Business Day

**URL:** <https://pug.phocassoftware.com/t/custom-period-previous-business-day/592>\
**Category:** Ask the Community\
**Tags:** howto\
**Created:** [May 7, 2018, 12:38am UTC](https://pug.phocassoftware.com/t/custom-period-previous-business-day/592 "2018-05-07T00:38:43Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![scopar](https://avatars.discourse-cdn.com/v4/letter/s/b3f665/32.png) [@scopar](https://pug.phocassoftware.com/u/scopar)\
**Post date:** [May 7, 2018, 12:38am UTC](https://pug.phocassoftware.com/t/custom-period-previous-business-day/592/1 "2018-05-07T00:38:43Z")

</div>

Hi,

Is there a way to create a custom period that will show the previous business day?

I can create one showing yesterday’s data, but hoping to see Friday’s data on a Monday morning by using this custom period, but then just the previous day for the rest of the week i.e. Monday’s data on a Tuesday, etc.

Is that possible?

Thanks,  
Scott

---

<div class="post-metadata">

**Author:** ![anon41607707](https://avatars.discourse-cdn.com/v4/letter/a/ac91a4/32.png) [@anon41607707](https://pug.phocassoftware.com/u/anon41607707)\
**Post date:** [May 8, 2018, 10:54am UTC](https://pug.phocassoftware.com/t/custom-period-previous-business-day/592/2 "2018-05-08T10:54:24Z")

</div>

Hi Scott, there are a couple of ways of achieving what I think you’re after. One of them is to use custom periods to define specific ranges of dates, ie a record for every

- Monday
- Tuesday
- Wednesday
- Thursday
- Friday, but where the Friday would also cover/include the dates for each Saturday and Sunday.

This way on a Monday using the above period range, the previous entry/period would show Friday, albeit with Saturday and Sunday, assuming these days held no relevance in terms of sales etc.

You would need to generate a custom period file/range to upload to your site, which covered all required date ranges as well as having to summarize by your custom period range as part of the build, so there may be additional build overhead and you may need to speak with the team in your region to better understand.

I hope this helps, but if you have any other questions please let us know!

---

<div class="post-metadata">

**Author:** ![anon90441911](https://avatars.discourse-cdn.com/v4/letter/a/a4c791/32.png) [@anon90441911](https://pug.phocassoftware.com/u/anon90441911)\
**Post date:** [May 8, 2018, 11:31am UTC](https://pug.phocassoftware.com/t/custom-period-previous-business-day/592/3 "2018-05-08T11:31:59Z")

</div>

Hi,  
An option will be setting up a new Period Type (eg: Week days), that contains Monday to Friday (exclude Saturday and Sunday). Then you can use Offset -1 in the period.  
Eg: With Offset -1 on 7/5/2018 - it will return 5/1/2018 sales  
With Offset -1 on 8/5/2018 - it will return 7/5/2018 sales.

Name Start Date End Date Year  
1/01/2018 1/01/2018 1/01/2018 2018  
2/01/2018 2/01/2018 2/01/2018 2018  
3/01/2018 3/01/2018 3/01/2018 2018  
4/01/2018 4/01/2018 4/01/2018 2018  
5/01/2018 5/01/2018 5/01/2018 2018  
8/01/2018 8/01/2018 8/01/2018 2018  
9/01/2018 9/01/2018 9/01/2018 2018

---

<div class="post-metadata">

**Author:** ![scopar](https://avatars.discourse-cdn.com/v4/letter/s/b3f665/32.png) [@scopar](https://pug.phocassoftware.com/u/scopar)\
**Post date:** [May 8, 2018, 11:17pm UTC](https://pug.phocassoftware.com/t/custom-period-previous-business-day/592/4 "2018-05-08T23:17:41Z")

</div>

Thank you @anon41607707 and @anon90441911. I like those ideas.

That all seems relatively simple.

I appreciate the quick responses.

Regards,  
Scott