#happy2022workday day-031
Happy 2022 day-031! Today’s update…
It’s the final day of January, 2022. We are celebrating the coming of February, because it is the start of monthly Customer Share-a-thons. They all have memorable dates: starting on 2/2 with Calc Fields, followed next month on 3/3 with Reporting, then 4/4 (theme TBD), etc. up to 12/12.
If desired, we could calculate the number of days in between each of these monthly Share-a-thons. How? We can use the DaTe Difference (DTD) calc field function type and specify the “Value Returned” to be “In Days” (see bottom right of pic.)
For those who are new to the DTD calc field function, it acts as the name suggests — it returns the difference between two dates. Those two dates need to be fields, either on the Business Object (BO) that holds this CF, or the Global BO. Workday does not allow you to simply enter a date such as February 2, 2022. Instead, if you want to use 2/2/22 as one of the two dates in a DTD, you just might need to create another CF, a DaTe Constant (DTC), if 2/2/22 does not already exist as a DTC CF.
All constants can be placed on the special “Global” Business Object (BO). By placing your constant CFs on the Global BO, they become available on all BOs, not just the Global BO.
Actually, the Global BO has some fields that don’t have a constant value. One of those is called “Today” (see bottom left of pic.)
Simple examples of DTD would be to calculate a worker’s tenure as the difference between Today and their Hire Date. Similarly, a worker’s age is the difference between Today and their Date of Birth.
CHALLENGE: This one is easy for those who understand DTD, and for many who are new to DTD but have followed this post with ease. Regardless, I understand why some hesitate as the wires in the brain might take a bit to connect. In this case, if you know the answer, please don’t comment so as to allow the wiring to happen for others. Here goes… How would you calculate the “Age at Hire” for workers?
Note that the mentioned examples of DTD for Tenure (“Length of Service”) and Age are used as simple explanation of using DTD and aren’t needed as Workday delivers these fields built-in. Even though those are built in, if you want to know somebody’s age in Days, now you know how to do that 🙂
Anyway, Workday delivers both Age and Tenure, but does not deliver “Age at Hire”, so that’s today’s challenge.