How to get the current employment start date of employee from employment history

(1) Share

Report

Posted on by Pooja Karki

3,045

Hello Everyone,

I am creating RunBase class and exporting employee data in excel format. Requirement is at runtime we will provide 2 dates which is compared with Employment StartDate in Employment history form (HCMEmployment.ValidFrom). Employement Start date is the ValidTimeState field in the HCMEmployment table.

Based on Users time zone the employment StartDate field value is changed but in DB it will store same value which we have entered.

e.g: if I am in India time zone and enter the value 31/12/2021 12:00:00 AM. When we change the user time zone to US or pacific zone it is changed to 01/01/2022 06:30:00 PM. In table field store the value " 31/12/2021 12:00:00 AM" this doesn't change.

So, whenever we run the report in US time zone and select the date 01/01/2022 it is generating blank report because table store 31/12/2021.

How can I handle this problem?

Thanks.

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Verified answer

Parag Chapre 12,254 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi Pooja,

You need to write below code in your class.

HcmEmployment hcmEmployment; ValidFromDateTime dateFrom = DateTimeUtil::minValue(); ValidToDateTime dateTo = DateTimeUtil::maxValue(); Timezone usertimezone = DateTimeUtil::getUserPreferredTimeZone(); utcdatetime utcFieldTimeBeginOfDay = DateTimeUtil::newDateTime(DateTimeUtil::date(datetoValidate), 0, usertimezone); utcdatetime utcFieldTimeEndOfDay = DateTimeUtil::newDateTime(DateTimeUtil::date(dateToValidate), #secondsPerDay - 1, usertimezone); // 23:59:59 of the day

In above case, you can use utcFieldTimeEndOfDay to get the value save in 23:59:59 format.

Please try above code and get back to me.

Was this reply helpful? Yes No
Suggested answer

Pooja Karki 3,045 on at

Like (0)

Report
Copy link

Link copied!

thanks for answer it works.

Was this reply helpful? Yes No
Suggested answer

Parag Chapre 12,254 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi Pooja, Can you please mark the answer as verified so that it can help others.

Was this reply helpful? Yes No
Pooja Karki 3,045 on at

Like (0)

Report
Copy link

Link copied!

Sure, will do that.

I just wanted to know if I want to print the changed date in report how I can do that?

If I changed time zone and whatever value is coming in Form same needs to print in report.

Was this reply helpful? Yes No
Parag Chapre 12,254 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi Pooja,

Is value in the form based on usertimezone or companytimezone?

Was this reply helpful? Yes No
Pooja Karki 3,045 on at

Like (0)

Report
Copy link

Link copied!

It is in Usertimezone.

Was this reply helpful? Yes No
Pooja Karki 3,045 on at

Like (0)

Report
Copy link

Link copied!

It is done thanks.

Was this reply helpful? Yes No