Which expression will accomplish this task?

You have a worksheet showing work orders. You are asked to report the date used to convert the calculated field EffectiveUnitPrice.

Which expression will accomplish this task?
A . DATEVALUE(EffectiveUnitPrice)
B . CONVERTONDATE(EffectiveUnitPrice, $ConversionDate)
C . DATETIMEVALUE(EffectiveUnitPrice)
D . ASSOCIATEDDATE(EffectiveUnitPrice)

View Answer

Answer: B

Explanation:

To report the date used to convert the calculated field EffectiveUnitPrice, the CONVERTONDATE function is the appropriate one to use. This function converts a measure’s value from one date to the value it would have on another date. The $ConversionDate variable (or similar) would typically be used within the worksheet to reference the date to which the conversion is applied.

ReferencesThe Kinaxis RapidResponse documentation on calculated fields and conversion functions explains how the CONVERTONDATE function is used to adjust financial measures based on changes over time, which would apply to fields such as EffectiveUnitPrice.