# Get Tomorrow At Midnight

**URL:** <https://community.tulip.co/t/get-tomorrow-at-midnight/5640>\
**Category:** Support, Troubleshooting, & Help\
**Created:** [June 23, 2022, 5:07pm UTC](https://community.tulip.co/t/get-tomorrow-at-midnight/5640 "2022-06-23T17:07:01Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![richard.vaughn](https://avatars.discourse-cdn.com/v4/letter/r/f07891/32.png) [@richard.vaughn](https://community.tulip.co/u/richard.vaughn)\
**Post date:** [June 23, 2022, 5:07pm UTC](https://community.tulip.co/t/get-tomorrow-at-midnight/5640/1 "2022-06-23T17:07:01Z")

</div>

Could somebody help me with writing an expression to get tomorrow’s date at midnight? I’m trying to load work orders with a run date of tomorrow, and in their current table, they’re saved T the specific date at midnight, and I’m unsure how to write an expression that gets the next day’s date at a specific time.

Thank you.

---

<div class="post-metadata">

**Author:** ![Pete\_Hartnett](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/pete_hartnett/32/3678_2.png) [@Pete\_Hartnett](https://community.tulip.co/u/Pete_Hartnett)\
**Post date:** [June 23, 2022, 5:12pm UTC](https://community.tulip.co/t/get-tomorrow-at-midnight/5640/2 "2022-06-23T17:12:41Z")

</div>

Hey @richard.vaughn

Check out these examples:

 ![image](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/e/ea801ec8dee8743dde4d4a8ff23241275b58e9e2.jpeg)

The underlying premise is pretty simple, take the current time, round down to the beginning of today, add X seconds to shift that time to another time.

Does this make sense?  
Pete

---

<div class="post-metadata">

**Author:** ![richard.vaughn](https://avatars.discourse-cdn.com/v4/letter/r/f07891/32.png) [@richard.vaughn](https://community.tulip.co/u/richard.vaughn)\
**Post date:** [June 23, 2022, 5:13pm UTC](https://community.tulip.co/t/get-tomorrow-at-midnight/5640/3 "2022-06-23T17:13:40Z")

</div>

Thanks for the quick response. I literally found the RoundDateTime() function right before this.

I’ve got it working now, cheers!
