Results 1 to 7 of 7
  1. #1
    Akchayan is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    Aug 2022
    Posts
    102

    Format from date (=Now())

    Hallo zusammen,


    ich habe diese Zeile in meinem Report:
    Click image for larger version. 

Name:	Screenshot 2022-11-15 163931.png 
Views:	16 
Size:	1.2 KB 
ID:	49119


    and for that I have given this format here: tt\.mmm\.jjjj

    but when I open the report, this is what comes out:
    Click image for larger version. 

Name:	Screenshot 2022-11-15 164105.png 
Views:	16 
Size:	1.3 KB 
ID:	49120
    but I want it to look like this: Endingen, 15.Nov.2022

    How do I solve this exactly?

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    Just use Date() ?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    Akchayan is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    Aug 2022
    Posts
    102
    Quote Originally Posted by Welshgasman View Post
    Just use Date() ?
    I tried that but then it looks like this: 15.11.2022
    but i would like it to look like: 15.Nov.2022

  4. #4
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    Ok, so look up the format function.
    https://support.microsoft.com/en-us/...3-63b9cd842530
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  5. #5
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  6. #6
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    I seem to recall that someone on another forum found out that they had to use the mm dd yyyy values instead of their language replacements for those values?

    Worth a try?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  7. #7
    Akchayan is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    Aug 2022
    Posts
    102
    Quote Originally Posted by Welshgasman View Post
    Ok, so look up the format function.
    https://support.microsoft.com/en-us/...3-63b9cd842530
    This worked, thank you.

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

Similar Threads

  1. 5 Digits Date to Normal Date Format
    By cyliyu in forum Access
    Replies: 7
    Last Post: 02-13-2022, 01:05 PM
  2. Replies: 6
    Last Post: 04-06-2020, 04:31 AM
  3. Replies: 3
    Last Post: 12-30-2016, 10:27 AM
  4. Replies: 3
    Last Post: 08-20-2014, 01:47 PM
  5. Replies: 4
    Last Post: 03-12-2013, 06:49 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