Who's On?

	Membership:
	Latest: Jeffin Joy
	Past 24 Hours: 1
	Prev. 24 Hours: 0
	Overall: 4988

	People Online:
	Visitors: 48
	Members: 0
	Total: 48

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

Years of Service

1 Replies

0 Subscribed to this topic

24 Subscribed to this forum

Sort:

Author

Messages

ccatino

New Member

Posts: 0

9/29/2006 1:37 PM

I'm using Crystal for the first time in three years and am a little rusty.

I know Lawson calculates years of service. You can see it in PA10 and pull it in HR65 reports with the HIRE DATE - YOS field.

I am trying to find it in the data dictionary but am not have much luck. Which table stores this field so I can pull it into a Crystal report?

Thanks.

John Henley

Posts: 3366

New Poster

Engaged Reader

Avid Reader

9/29/2006 4:10 PM

EMPLOYEE table; field DATE-HIRED.