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.