U Unicon Registered User. Local time Today, 20:52 Joined Dec 24, 2009 Messages 123 Nov 12, 2012 #1 Dear all, I have a query with field of [DateofJoining] I want to create another field and want to see the value that what date will come after 22 months for that [DateofJoining] field. Please advice.
Dear all, I have a query with field of [DateofJoining] I want to create another field and want to see the value that what date will come after 22 months for that [DateofJoining] field. Please advice.
pr2-eugin Super Moderator Local time Today, 16:52 Joined Nov 30, 2011 Messages 8,487 Nov 12, 2012 #2 Hello Unicon, Try this.. Code: SELECT [DateofJoining], DateAdd("m",22,[DateofJoining]) AS [DateAfterSomeMonths] FROM theTable;
Hello Unicon, Try this.. Code: SELECT [DateofJoining], DateAdd("m",22,[DateofJoining]) AS [DateAfterSomeMonths] FROM theTable;
U Unicon Registered User. Local time Today, 20:52 Joined Dec 24, 2009 Messages 123 Nov 12, 2012 #3 Thanks pr2-eugin it work fine
