Results 1 to 7 of 7
  1. #1
    Starmo is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Jun 2018
    Posts
    43

    Format the date

    Hello guys!


    How to format a field in the form to insert a date in the table as a month and a year. Let's say:


    01.2018

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Depending on what you are doing:
    Format([ControlName],"mm.yyyy") or Format([FieldName],"mm.yyyy")
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    Starmo is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Jun 2018
    Posts
    43
    Quote Originally Posted by ridders52 View Post
    Depending on what you are doing:
    Format([ControlName],"mm.yyyy") or Format([FieldName],"mm.yyyy")
    I did not understand you well!

    I have this situation. In form I have two dates, which are transferred to the table.
    In the column Date 1 are showing well on date 20.06.2018, but we need in Date 2 column to appear in form 05.2018 (should be month back).

  4. #4
    Starmo is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Jun 2018
    Posts
    43

    Format the date

    This looks like somehow. How to do this?
    Attached Thumbnails Attached Thumbnails Form.PNG   Datum.PNG  

  5. #5
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    OK - I was describing formatting for VBA code - ignore that

    Whilst Text4 is selected, select the Format tab on the property sheet.
    Then in the Format row (top line) enter mm\.yyyy

    FYI the \ is used to ensure the following character appears as written - in this case a full stop e.g. 05.2018
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  6. #6
    Starmo is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Jun 2018
    Posts
    43
    Quote Originally Posted by ridders52 View Post
    OK - I was describing formatting for VBA code - ignore that

    Whilst Text4 is selected, select the Format tab on the property sheet.
    Then in the Format row (top line) enter mm\.yyyy

    FYI the \ is used to ensure the following character appears as written - in this case a full stop e.g. 05.2018
    Bravo master. This is working. Thank you!

  7. #7
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    You're welcome
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 01-14-2018, 08:59 PM
  2. Replies: 3
    Last Post: 12-30-2016, 10:27 AM
  3. Replies: 3
    Last Post: 08-20-2014, 01:47 PM
  4. Replies: 4
    Last Post: 03-12-2013, 06:49 PM
  5. Date field not in date format
    By Lorlai in forum Access
    Replies: 11
    Last Post: 06-27-2011, 05:14 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums