Results 1 to 3 of 3

How to show "now()" without time displayed surrounded by text in report

  1. #1
    jmuirman1 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Aug 2016
    Posts
    57

    How to show "now()" without time displayed surrounded by text in report

    USING TEXT BOX ab|.

    STRING IS:


    ="The benefits and prices above are for illustration purposes only and are not to be construed as a contract or guarantee of benefits or payments of any kind. Additionally, the prices quoted are good for only 7 days from " & Now() & " or the effective date of a rate change from the life insurance company writing the annuity, whichever is earlier."

    THIS RETURNS: The benefits and prices above are for illustration purposes only and are not to be construed as a contractor guarantee of benefits or payments of any kind. Additionally, the prices quoted are good for only 7
    days from 12/8/2019 10:35:39 AM or the effective date of a rate change from the life insurance
    company writing the annuity, whichever is earlier.

    I WANT TO ELIMINATE THE TIME.

    THANKS,

    JOHN

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    6,654
    just use Date() instead of Now() ?
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    "Everyone has a photographic memory; some just don't have film." Steven Wright

  3. #3
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    420
    Code:
    ?format(#12/8/2019 10:35:39 AM#,"mm/dd/yyyy")
    12/08/2019

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

Similar Threads

  1. Replies: 1
    Last Post: 06-21-2019, 06:17 AM
  2. Replies: 17
    Last Post: 02-13-2015, 06:24 AM
  3. Replies: 1
    Last Post: 01-05-2013, 10:46 PM
  4. Export "Query or Report" to a "Delimited Text File"
    By hawzmolly in forum Import/Export Data
    Replies: 3
    Last Post: 08-31-2012, 08:00 AM
  5. Replies: 3
    Last Post: 11-15-2011, 02:41 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
  •  
Tech Forums: Microsoft Office Forums