in Date field I just want it to show current Month & Year. and same should be added in table.
how can I write the code. Or how can I do it
in Date field I just want it to show current Month & Year. and same should be added in table.
how can I write the code. Or how can I do it
Just curious--- Why?
If you have a Date datatype, you can store the full Date.
In queries etc you can use Format or Month or Day or Year built in function(s).
In a table called Ancestor, I have a field called BirthDate which is date datatype
gives a resultCode:SELECT Day([birthdate]) AS D, Month([birthdate]) AS M, ancestor.birthdate FROM ancestor;
D M birthdate
31 10 31/10/1922
22 3 22/03/1944
1 11 01/11/1922
9 9 09/09/1999
thx I solved the problem
In Table Design View and In Format I wrote mmmm - yyyy
this gives me month & year