Inserting Default Month and Year

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I understand how to format for the current date by using Date() but would
like to format two separate fields with Year only in one and Month only in
another. I have tried Year() and Month() but they do not work.

Thank you for your help!
 
Hi Samiran

Of course you can split the month and year "part" from a date/time field but
if it is only for information of a user you could simply format the controls

Set the format of the Year control to either yy or yyyy
Set the format of the Month control to either mm or mmmm

The control source will still be Date() for both

Hope this helps
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Vba to change displayed year automatically. 14
retrieving previous year and month 1
Access 2 Digit year in Access Text Box 3
Creating a table of summaries by month...? 1
MM/DD date format no year 5
Calculate Years of Service 11
Extracting Month and year 1
Calculating Age in Years and months in a form 2

Back
Top