Get Tomorrow At Midnight

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.

Hey @richard.vaughn

Check out these examples:

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

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

I’ve got it working now, cheers!

1 Like