05-31-2011, 03:51 PM
(This post was last modified: 05-31-2011, 03:51 PM by AutomationTester2011.)
Vins and chalam
Sorry guys..just b4 i saw ur replies...i also got solution as below..thanks a lot
Sorry guys..just b4 i saw ur replies...i also got solution as below..thanks a lot
Code:
currDate = FormatDateTime(Date, 2)
year1 = right(currDate, 4)
month1 = mid(currDate, 4, 2)
day1 = left(currDate, 2)
newdateformat =year1& "-" &month1& "-" &day1
PRINT newdateformat