Results 1 to 2 of 2

Thread: Long date

  1. #1
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have the following control in my report:
    ="Payment :" & "" & [required date]
    I have placed the format to long date but nevertheless i get the result with a short date. How can i format it to a long date ?

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Since you are manipulating the data instead of just displaying the data, you need to tell Access how to format the concatenation of the date

    ="Payment :" & Format([required date],"dddd, mmmm dd,yyyy")


    You don't need the highlighted part of the formula ="Payment :" & "" & [required date]. You are adding an empty string to a string. It's the same as adding 0 (zero) to a number.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •