In what format are dates returned by a Lawson Query?

I have a need to determine the number of days between two dates (DATE-HIRED and TERM-DATE) from the EMPLOYEE table. I know that in order to use the date diff function the fields need to be set to a type of date. What I can't figure out is what type the data from the query is.

Find more posts tagged with

Process Automation (IPA) - General Discussions

Accepted answers

All comments

Legacy Contributor

The DME format is returned by query of the Lawson database.

Mm/dd/ccyy

The AGS format matches the format of dates in the Lawson database.

Ccyymmdd

rm_benefit_administration_aca_training.pptx

Legacy Contributor

I know that is what it looks like. The question is does that mean it's returned as a text field, rather than a date field.

Legacy Contributor

Hi ChelleR, where are you performing the query that is using the DATEDIFF() function? Any value that SQL Server recognizes as a date can be used in the function. If you are pulling DATE_HIRED AND TERM_DATE from the EMPLOYEE table, you can just say DATEDIFF(DD,DATE_HIRED,TERM_DATE). Be aware that the function will only give you results I think you are looking for if the employee *has* a term date. If the term date is blank on HR11, the TERM_DATE in the EMPLOYEE table is 01-01-1753.

Attachment_4485.zip

Legacy Contributor

I was using a Lawson query, but will use SQL so that I can use datediff. Thanks.

Copyright © 2025 Infor. All rights reserved.