Hello Everyone,
One of my suppliers is requesting the date (currentDate) to be in the following format:
22A3 <-- (the actual date is January 22nd / 2003)
*22 is the day (2 digits)
*The A is a code for the month (Jan=A, Feb=B, March=C, April=D, May=E, June=F, July=G, August=H, Sept=I, Oct=J, Nov=K, Dec=L)
*The 3 is the fourth digit in the year.
What formula do I need to write to accomplish this?
Thank you and Best regards
Basel
IP Logged
