How to trim the date using fast formula to show only the date and not time
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'