ME $MM-DD-YY to DD-MMM-YYYYHpZ@?Z@e\(?Z@@----------------------------------------------------------------------------------------------------------------------------------TN MM-DD-YY to DD-MMM-YYYY - Convert a date from MM-DD-YY to DD-MMM-YYYY formatT----------------------------------------------------------------------------------------------------------------------------------TUsesT: T9 - Temporary work variable contains Date Time commandT1 T10 - Contains incoming date in MM-DD-YY formatT9 T11 - Will receive converted date in DD-MMM-YYYY formatT T15 - MonthT T16 - DayT T17 - YearT----------------------------------------------------------------------------------------------------------------------------------TTU-------------------------------------------------------------------------------------T&Put the date in T10 in MM-DD-YY formatTU-------------------------------------------------------------------------------------T| 07-10-08TTU-------------------------------------------------------------------------------------T2Parse date to get MM, DD, YY in separate variablesTU-------------------------------------------------------------------------------------T Get MonthT  T1T2T Get DayT  T4T2T Get YearT  T7T4T Add 20 to convert 08 to 2008TT N-12000T| 20%T17%TTTU-------------------------------------------------------------------------------------T_Here is the trick, create a macro command in text format to get the date in a specified format.T5Then run the macro command contained in the variable.TU-------------------------------------------------------------------------------------T4Put correct Day of Week for the date in variable T11T|2007T!Here: T2 = Day, N4=Month, T5=YearT,T|8TT$ DD-MMM-YYYYT 2 7/10/200812:00:00 AMTTTT6=T1CenterCenter000278000200000 View ResultView Result: %T11%TTerminate Macro Expressۡs@Run Macro Express EditorYܡs@Start / Stop CaptureWwݡs@ Resume Pausecޡs@!Menu of Macros for Topmost Windowޡs@ Suspend / Resume Macro Expressoߡs@\BP BP 6666