# Creating Streams

**URL:** <https://pug.phocassoftware.com/t/creating-streams/1379>\
**Category:** Ask the Community\
**Created:** [December 9, 2019, 10:16pm UTC](https://pug.phocassoftware.com/t/creating-streams/1379 "2019-12-09T22:16:12Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![KellyS](https://avatars.discourse-cdn.com/v4/letter/k/22d042/32.png) [@KellyS](https://pug.phocassoftware.com/u/KellyS)\
**Post date:** [December 9, 2019, 10:16pm UTC](https://pug.phocassoftware.com/t/creating-streams/1379/1 "2019-12-09T22:16:12Z")

</div>

I am relatively new to this product and need to know **just how to create a new stream beside existing ones**. The documentation is scant. For example, in our AP Database, we have a Date basis and stream by Invoice Date. We would like to add a stream (Date basis) by Apply Date. Apply Date is one of the columns in the SQL Query and has a red dot above it. Any help would be greatly appreciated. Do I need to write a new SQL script?

---

<div class="post-metadata">

**Author:** ![aaron.roma](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/aaron.roma/32/285_2.png) [@aaron.roma](https://pug.phocassoftware.com/u/aaron.roma)\
**Post date:** [December 10, 2019, 3:55pm UTC](https://pug.phocassoftware.com/t/creating-streams/1379/2 "2019-12-10T15:55:13Z")

</div>

Have you taken a look at the Phocas Academy? When I was first starting out, I found those videos very helpful. This one in particular, will give you a good overview of how the Designer works.

> **[Design your own database](https://www.phocassoftware.com/academy/videos/di6yld67r1?hsLang=en)**
>
> Learn how to design a new database using our Designer tool. In this video for administrators Tim steps you through connecting to your data source and using drag and drop to map and customize the data. Watch the database build and open straight away...

That being said, if you’re just trying to create a new stream, identical to the first, but based on a different date, that should be fairly easy.

(Note, please be careful in designer… you could screw up what’s already working for you!)

Start by cloning your original stream:  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/phocassoftware/original/1X/faec53e3d18580a6aade4815916c5c4ddc41fe9e.png)

Edit the name of the new stream:  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/phocassoftware/original/1X/c8920e9ac5b3cf090574f78281fc0da327f74be7.png)

Remove the current date (upper right):  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/phocassoftware/original/1X/fd2f1a7dd6a00c712f3fb5cfe5e541caa459a4e0.png)

Down in the preview section, grab the new date, and drag it up and drop it on the date field in the upper right.  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/phocassoftware/original/1X/f1f88e69344501c5494f2e7f0c5883d46ddf3cbb.png)

Now this new stream’s periods are based on the new date you selected. You’ll want to go to the build tab at the top, and save and build your database for the new stream to show.

---

<div class="post-metadata">

**Author:** ![KellyS](https://avatars.discourse-cdn.com/v4/letter/k/22d042/32.png) [@KellyS](https://pug.phocassoftware.com/u/KellyS)\
**Post date:** [December 20, 2019, 9:43pm UTC](https://pug.phocassoftware.com/t/creating-streams/1379/3 "2019-12-20T21:43:17Z")

</div>

Thank you aaron.roma! That is exactly what I needed!