Advance datetime to just after midnight

[Phil_P]

Hi all,

Looking for some help with what (I think) should be a simple fomula.

I have a date time-field called [startdate]. if the time is after 12:00 I need to advance the date-time to 1 second past midnight on the following day, In SQL I would probably use datefromparts() but I cant see a direct equivalent in Alteryx. Any idea on the easiest way to implement?

Regards

Phil

[DavidP · Accepted solution]

This should do it

[Phil_P]

perfect, thank you