# What happens when you use "Add date & time" and offset by -1 month

**URL:** <https://community.parabola.io/t/what-happens-when-you-use-add-date-time-and-offset-by-1-month/3093>\
**Category:** Ask a question\
**Tags:** Building-Flows\
**Created:** [December 4, 2024, 7:56pm UTC](https://community.parabola.io/t/what-happens-when-you-use-add-date-time-and-offset-by-1-month/3093 "2024-12-04T19:56:30Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Brian\_Sage](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/brian_sage/32/2245_2.png) [@Brian\_Sage](https://community.parabola.io/u/Brian_Sage)\
**Post date:** [December 4, 2024, 7:56pm UTC](https://community.parabola.io/t/what-happens-when-you-use-add-date-time-and-offset-by-1-month/3093/1 "2024-12-04T19:56:30Z")

</div>

When using the “Add date & time” function, what do you get when you offset by -1 months and the current day is Mar 31, 2024?

Since Feb 2024 had 29 days, do you get “Feb 29”, or do you get something like “Feb 31”, “Mar 2”, etc?

Similarly, when the year rolls over to “Jan 05, 2025”, do you get “Dec 05, 2024” or “Dec 05, _ **2025** _”?

---

<div class="post-metadata">

**Author:** ![Colleen\_Cole](https://avatars.discourse-cdn.com/v4/letter/c/ce7236/32.png) [@Colleen\_Cole](https://community.parabola.io/u/Colleen_Cole)\
**Post date:** [January 6, 2025, 6:30pm UTC](https://community.parabola.io/t/what-happens-when-you-use-add-date-time-and-offset-by-1-month/3093/2 "2025-01-06T18:30:52Z")

</div>

Today is January 6. I am updating some flows that I run to collect sales data.

Hopefully these screenshots will answer your question.

 ![Offset to the previous period](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/d/d4655bd337cf3779455188931a769d4dc106079e.jpeg)  
 ![No offset](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/2/29649d02e5fbf83e67f71d1efd17f24183a5bd65.jpeg)

---

<div class="post-metadata">

**Author:** ![Cat\_Tang](https://avatars.discourse-cdn.com/v4/letter/c/35a633/32.png) [@Cat\_Tang](https://community.parabola.io/u/Cat_Tang)\
**Post date:** [January 7, 2025, 8:46pm UTC](https://community.parabola.io/t/what-happens-when-you-use-add-date-time-and-offset-by-1-month/3093/3 "2025-01-07T20:46:44Z")

</div>

![Screenshot 2025-01-07 at 3.44.52 PM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/9/93a72829d309c2f0a5a40fe87b5908687e925dfd.png)

Hi Brian,

Thanks for writing in! To answer, we’ll take the last day of February (this year, 28 days in Feb) so March 31 offset by 1 month goes to 2/28.

For Jan 05 offset, we subtract a month to the previous year. Hope these make sense!

 ![Screenshot 2025-01-07 at 3.46.13 PM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/9/926ed1b480c48ab324cde2a4a618fcee6a795b6e.png)

---

<div class="post-metadata">

**Author:** ![Brian\_Sage](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/brian_sage/32/2245_2.png) [@Brian\_Sage](https://community.parabola.io/u/Brian_Sage)\
**Post date:** [January 8, 2025, 3:39pm UTC](https://community.parabola.io/t/what-happens-when-you-use-add-date-time-and-offset-by-1-month/3093/4 "2025-01-08T15:39:22Z")

</div>

Yes, that’s perfect! Thanks, @Cat_Tang and @Colleen_Cole