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
 
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")
 
Back
Top