BPM Expression for INT DateTime?

Anyone know how I could use in a BPM SetField expression to get current Date/Time as integer?

OrderHed, ShipHead, etc tables have a ChangeTime field that’s INT time.

The field I need to write to is datatype INT.

That’s seconds since midnight (generally)

(DateTime.Now-DateTime.Today).TotalSeconds
2 Likes

I knew I was making it harder than it really is.

I owe you a drink Jose!

1 Like