x Want to participate? Join the group to interact

Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Customization and Productivity Sage Alerts TimeUpdate field

Sage Alerts TimeUpdate field

SOLVED

Posted By 49153 over 8 years ago

I want to pull the TimeUpdate field from Sage 100 into Sage Alert emails.

Does anyone have any tricks to convert the number to a time format?

0 BadgerJerry over 8 years ago

sagecity.na.sage.com/.../93885
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 49153 over 8 years ago in reply to BadgerJerry

I can do math.... but where exactly do you do that in Sage Alerts?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 TomTarget over 8 years ago in reply to 49153

Query definitions | columns tab - click the button that says Add Calculated Column to Query - enter the math.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 49153 over 8 years ago

verified answer

FORMAT("SO_SalesOrderHeader"."TimeUpdated"/24,'hh:mm AM/PM')
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel