How to convert date input as String in YYMMDD to MMMDDYY format by adding 2 with imput date

[Bags]

Hi 

I'm fairly new to AutoIT. I am trying to convert dates from one format to other. My input date is in format "YYMMDD" e.g. (121130) . I have to add 2 days to it and output should be in "MMMDDYY" e.g. (DEC0212) format. Both the input and output is String. I searched the existing date time related functions but couldn't find any suitable implementation there. 

[jchd]

Try this:

#include <Date.au3>

Local Const $aMonths = ["JAN", "FEB", "MAR", "APR", "MAY", "JUN", "JUL", "AUG", "SEP", "OCT", "NOV", "DEC"]
Local $DateIn = "121130"
Local $DateInISO = _DateAdd("D", 2, StringRegExpReplace($DateIn, "(\d\d)(\d\d)(\d\d)", "20$1/$2/$3"))
Local $DateOut = Execute(StringRegExpReplace($DateInISO, "20(\d\d)/(\d\d)/(\d\d)", "$aMonths[$2 - 1] & '$3$1'"))

ConsoleWrite($DateOut & @LF)

 

Edited May 26, 2017 by jchd

[water]

Welcome to AutoIt and the forum!

This UDF allows to do all kind of date/time conversions:

The wiki has a page with > 300 UDFs for all kind of tasks

[Bags]

Great. Thanks a  lot  for your help jchd! 

[Bags]

Hey jchd, your solution  doesn't work if year changes i.e if input is "121230", I'm getting output as "JAN0101". An yhelp on this?

[jchd]

Sorry for the typo. Code fixed above.

[Bags]

Cool! Thanks  I got it .