date format as part of concatenation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want a new field to be created call Update for use in a report as
abreviation of data

Update: Steps!Updater & " " & Steps!Updated

to give this format --> N411303 Sun 21 May 06 (Updater is login
ID eg N411303)

Unfortunately my formula gives : N411303 21/05/2006 15:07:46

How can I format to get the date part looking as I want it? In the table
the 'Updated' field is formatted hh:nn ddd dd mmm yy as I use it elsewhere
for other reports etc
 
Update: Steps!Updater & " " & Format(Steps!Updated , "dddd dd mmmm
yyyy")
 
Correct solution, but wrong format.
Sample given: N411303 Sun 21 May 06

Update: Steps!Updater & " " & Format(Steps!Updated, "ddd dd mmmm yy")

If the original poster wanted the 3-Character month abbreviation instead of
the full month name
Update: Steps!Updater & " " & Format(Steps!Updated, "ddd dd mmm yy")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Week starts on Friday 2
Query to get sum of a field if two fields match 5
Change format of date in query? 3
format date 7
Sorted and Unique Date Period 2
Creating query without using Wizard 6
Problem with date format?? 10
Date format. 1

Back
Top