PDA

View Full Version : [SOLVED:] Replacing a Date Extracted From a String



Opv
08-13-2018, 10:50 AM
The values "8/12/2018" and "8/13/2018" are substrings within two separate longer text strings, STRING1 and STRING2 respectively. I can easily extract those dates and compare them. Is it possible to use the REPLACE function to replace the older date in STRING1 with the more recent extracted date from STRING2?

Opv
08-14-2018, 06:17 AM
I think I may have solved my dilemma. It appears that dimming the substrings as dates was preventing the REPLACE and SUBSTITUTE functions from performing the desired replacement. Dimming the substrings as strings seems to work.