I am trying to read date values from two fixed cells from two different tabs of Excel and then perform substring on one of the values if required.
Need to compare these dates only when both are not NULL. One is in YYYYMMDD format and one is in proper MM/DD/YYYY format. It may happen that the second cell may contain only YYYY.
so I need to convert YYYYMMDD into date and then perform comparison with MM/DD/YYYY in case the second cell has MM/DD/YYYY or just compare YYYY from first value with YYYY in case the second cell only has year.
It seems really difficult to do this with Pega. I have spent 4-5 hours on this already but to no avail. It seems C# script is an easy way here. Can someone please show if I can do this using PEGA. I am attaching two sample excel files. The result needs to be written in third tab saying values match/ do not match or value is missing. I have attached 3 simple excel files with 3 cases.