Thank you for your quick response Siva. My interest is to find how all the string functions could be used.
(e.g.) to calculate the number of weeks between 29/5/1968 and 26/5/1999 use DateDiff(1,MakeDate(29,5,1968), MakeDate(26,5,1999)). This will correctly return 1617.
Likewise, I'm sure there would be plenty of string functions if not exhaustive. Could you please help me with as much information on this as possible. I'm doing an assignment and in need of it. Thank you so much for your time in this.