I have 2 date columns in format DD/MM/YYYY - 1 column contains Premium Pmt date (PPD) & the Other column is Today date (TODAY).
I want to do the following:
Split PPD into DD/MMM ; such that the Year component goes away completely (is not stored).
Split TODAY into DD/MMM ; same as above.
Calculate DIFFERENCE between Split PPD - Split TODAY
I did the following - Used formatDate to split the 2 columns into DD/MMM
The problem - When I am using dateBetween & inputting formatDate output as dates, I found out that it converts date into string and is accepting these inputs.
Can you please help me. My purpose is to remove year from the 2 columns and then compare the two just on basis of DD/MMM.
Attached screenshot below -