I have a requirement of subtracting months/years from the date to identify the previous date.
I have a requirement of subtracting months/years from the date to identify the previous date. Following is the implementation that I have done to achieve that:
1. Generate Attribute operator is used to get the PREVIOUS date:
PREVIOUS_DATE = date_add(date_parse_custom(ACCOUNT_INFO_DATE,"MM/dd/yyyy"),-1,DATE_UNIT_MONTH)
ACCOUNT_INFO_DATE consist of nominal date which is in "MM/dd/yyyy" format
ACCOUNT_INFO_DATE = 04/30/2021
PREVIOUS_DATE = 03/30/2021
Ideally, It should be 03/31/2021 as we are subtracting 1 month from the date.
I have attached the process for reference that I am trying
Thanks in advance