Q. Convert the date from first format to the second format and sort in ascending order.
Date (yyyymmdd.000) Date (mm/dd/yyyy)
20051220 12/20/2005
20061202 12/02/2006
20070112 01/12/2007
20070519 05/19/2007
20070523 05/23/2007
20070623 06/23/2007
20070624 06/24/2007
20071017 10/17/2007
20080419 04/19/2008
Current Date 7/23/2024 Last Modified Date #NAME?
Current Time 09:56:00 AM Last Modified Time #NAME?
Name Birthdate Day(in Number) Month(in number) Month(in text) Year
Boneca Rego 14-Nov-99 14 11 November 1999
Rajeev Singh 16-May-01 16 5 May 2001
Gururaj Joshi 21-Nov-03 21 11 November 2003
Sudesh Pillai 6-May-04 6 5 May 2004
Yashraj Vaidya 7-Apr-05 7 4 April 2005
Dinesh Dhanuka 2-Feb-09 2 2 February 2009
Yogesh Mansharamani 1-Jun-10 1 6 June 2010
Ram Ambradkar 13-Nov-10 13 11 November 2010
Ruffina Joshi 31-Jan-11 31 1 January 2011
Simon Rodrigues 6-May-13 6 5 May 2013
Dhiren Sheth 23-Jan-15 23 1 January 2015
Ashok Samtaney 30-Apr-15 30 4 April 2015
Age(in years) Exact Age with Years,Month,days
24 24 Years, 8 Months, 9 Days
23 23 Years, 2 Months, 7 Days
20 20 Years, 8 Months, 2 Days
20 20 Years, 2 Months, 17 Days
19 19 Years, 3 Months, 16 Days
15 15 Years, 5 Months, 21 Days
14 14 Years, 1 Months, 22 Days
13 13 Years, 8 Months, 10 Days
13 13 Years, 5 Months, 22 Days
11 11 Years, 2 Months, 17 Days
9 9 Years, 6 Months, 0 Days
9 9 Years, 2 Months, 23 Days
