Results 1 to 2 of 2
  1. #1
    Access77 is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2019
    Posts
    2

    Simple Expression Builder Question

    I am creating the Access expression builder to create a field in a table, drawing from other fields in the same table.



    I have an existing date field in the table that has the format dd/mm/yy.

    I want to get the month from this existing date field.

    The expression I am using is:

    & Month([Date])

    This works, but for single digit months (eg January), only return 1

    I need the returned value to be 01.

    Can someone please assist.

  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
    Crossposted with answers at both https://www.access-programmers.co.uk...d.php?t=306613 and https://www.utteraccess.com/forum/in...ic=2054963&hl=

    @Access77
    Please read this article about the etiquette of crossposting https://www.excelguru.ca/forums/show...-cross-posters
    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. Expression Builder IIF() Question
    By wtucker in forum Programming
    Replies: 7
    Last Post: 07-31-2017, 06:40 AM
  2. Replies: 4
    Last Post: 05-03-2016, 01:51 PM
  3. Replies: 1
    Last Post: 07-28-2014, 01:50 PM
  4. Another simple expression question!
    By brownk in forum Queries
    Replies: 11
    Last Post: 05-25-2012, 12:04 PM
  5. An Expression Builder Question
    By ddkolb in forum Reports
    Replies: 3
    Last Post: 06-03-2011, 04:51 PM

Tags for this Thread

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