Derived Field to Return Field Value on Specific Effective Date

Hi,

Some forms we sent out in prior years are updating on the user view. Does anyone know of a way to create a derived field that would return a value on a specific effective date?

Something like:

ZZZHourlyRate is a DerivedField

type is Decimal size 8.2

return HourlyRate where effective date = "04/01/2021"

Find more posts tagged with

LSF/Landmark Development

Accepted answers

Dr. Awesome

Ok, assuming this is on WorkAssignment? If so, try this:

return WorkAssignment(as of SomeDate).HourlyRate

I think the issue was HourlyRate is already a DerivedField and the sytax I used didn't apply

All comments

Dr. Awesome

Check this syntax out:

return HourlyRate(as of effective date)

return HourlyRate(as of SomeDate)

Lavanya

Hi,

I tried this and it is giving syntax error. I am not able to save the derived field. any specific screenshot could be helpful.

Dr. Awesome

Ok, let me review/sort this. Should be possible to do something like this, I think.

Dr. Awesome

Ok, assuming this is on WorkAssignment? If so, try this:

return WorkAssignment(as of SomeDate).HourlyRate

I think the issue was HourlyRate is already a DerivedField and the sytax I used didn't apply

smodarressiyazdi

Hi -

Thank you for your help. This worked for me. To put it all together if it's helpful for someone in the future:

HourlyRate is a delivered derived field on the WorkAssignment business class.

ZZZHourlyRate is a DerivedField

type is Decimal size 8.2

return WorkAssignment(as of ZZZEffectiveDate).HourlyRate

ZZZEffectiveDate

type is Date

return "2022040"

Lavanya

Thanks @Dr.Awesome, It works perfect

Copyright © 2025 Infor. All rights reserved.