How to trim the date using fast formula to show only the date and not time — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to trim the date using fast formula to show only the date and not time

edited Sep 5, 2020 12:17AM in Compensation 3 comments

Summary

have written the following FF to retrieve the date values from the DFF. The value is getting retrieved, only the format is wrong. Can you pls. help me in defining the correct format.

Content

/*=========== DATABASE ITEM DEFAULTS BEGIN ==============*/
DEFAULT FOR PER_ASG_ATTRIBUTE_DATE1 IS '4712/12/31' (date)
DEFAULT FOR L_DEFAULT_VALUE IS '4712/12/31' (date)
/*=========== DATABASE ITEM DEFAULTS END ================*/
/*=========== INPUT SECTION BEGIN ==============*/
INPUTS ARE CMP_IV_PLAN_ID (number)
/*=========== INPUT SECTION ENDS ==============*/
/*=========== FORMULA SECTION BEGIN =====================*/
L_DEFAULT_VALUE = PER_ASG_ATTRIBUTE_DATE1
RETURN L_DEFAULT_VALUE
/*=========== FORMULA SECTION END =====================*/

Attached is the output received. Want to truncate the output to show only the date in the format 'MM/DD/YY'

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!