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