Skip to Content
0
Former Member
Jun 04, 2013 at 01:55 AM

Length of services in Ad hoc query

65 Views

Dear Expert,

I have difficulty to query length of services from the ad hoc query.

Below is the details:

Date specification (IT0041)

subtype 01 (date start working within the country)

subtype 50 (date join current company)

Ad hoc query selection and filter:

EE ID : display

Entry date : display

leaving date : display

Length of service (years) : display

Length of service (months) : display

Length of service (days) : display

data display for length of services is according Enter date.

If I filter date type (subtype 50), it's still display the length of services according the entry date.

May i know how to filter the date type to make the length of services is according date type 50?

Appreciate your advice.

Thanks,

Mel