Hi Sukhdeep Sorry for misunderdstanding. the CITY field is a string, so the first thing is to extract the date: find(#CITY, "\d{8}") - extract a sequence of 8 digit characters Second is to convert this to a date: s2d(find(#CITY, "\d{8}"), "yyyyMMdd") - convert string to...