Derived Fields and Syntax Questions

athomas2

Hello,

Brand new to this....

I need to configure a few fields for our HRIS department to use on a report.  They need three fields that return the Current Date - 7 days, Current date - 14 and Current date - 31 days.  

Should this syntax work where X = 7, 14 or 31?

return (CurrentCorporateDate - X days)

If so, what Business Class should be used?  And these would be Derived Fields with Field Type = Date, correct?

Additionally, what syntax should be used to trim any trailing spacing at the end of Name.MiddleInitial?

I tried the below on the Employee BC and received errors.

Name.MiddleInitial using “s+$” or “s+

Thank you so much for your help,

Alecia

Dr. Awesome

How will they be using these three new Derived Fields? I ask because if they aren't part of a calculation they shouldn't need to be configured Derived Fields as this can be done inline in the report itself as a compute field.

(current corporate date - 7 days) is the right syntax either way, assuming you want to use the "corporate" date, else you'd use (current date - 7 days) . The Derived Field type of "Date" is probably perfect (it depends how you want to use it)