concatenation of a date

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

Guest

Hi folks,

Trying to generate a reference number from two fields, one of which is a date field. I can't control the date field:

What's I've got:
field1 - WD101
character - /
date - 01-Nov-03

What's happening:
WD101/01/11/2003

What I want
WD101/011103

How can I control the date output?

Thankx in advance,

Piers.
 
Format([MyDate], "ddmmyy")

should work to get the date formatted the way you want it.

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Piers said:
Hi folks,

Trying to generate a reference number from two fields, one of which is a
Click to expand...
date field. I can't control the date field:
 
Thankx!

----- Cheryl Fischer wrote: -----

Format([MyDate], "ddmmyy")

should work to get the date formatted the way you want it.
 
You're welcome.

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Piers said:
Thankx!

----- Cheryl Fischer wrote: -----

Format([MyDate], "ddmmyy")

should work to get the date formatted the way you want it.

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Piers said:
Hi folks,
Click to expand...
which is a
date field. I can't control the date field:
field1 - WD101
character - /
date - 01-Nov-03
Click to expand...
Click to expand...
 
Back
Top