Sage 300

Welcome to the Sage 300 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.

AUDTTIME field

Posted By SaskPeter over 8 years ago

Greetings!

Is the AUDTTIME field in say, APIBH, a datetime datatype field? I get a

"Arithmetic overflow error converting expression to data type datetime" when trying to convert to local time.

0 Ettienne Schwagele over 8 years ago

It's a number in the format HHMMSS00.

How/where are you trying to use it?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 SaskPeter over 8 years ago in reply to Ettienne Schwagele

I am trying to convert that time to local time. I gather it is in UTC (the AUDTTIME value pulled off the database)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Ettienne Schwagele over 8 years ago in reply to SaskPeter

UTC

Using Crystal?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Ettienne Schwagele over 8 years ago in reply to Ettienne Schwagele

www.blogger.com/blogger.g
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 SaskPeter over 8 years ago in reply to Ettienne Schwagele

Ok.

No, just a SQL query. I want to see the time in local time to show a client. So was trying to convert and am getting the arithmetic overflow error..
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 FormerMember over 8 years ago in reply to SaskPeter

The AUDTTIME is shown in GMT format - hence work our your timezone and add the hours accordingly.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 300

AUDTTIME field

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING