concatenation of a date

[Piers]

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.

 

[Cheryl Fischer]

Format([MyDate], "ddmmyy")

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

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

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:

 

[Piers]

Thankx!

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

Format([MyDate], "ddmmyy")

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

 

[Cheryl Fischer]

You're welcome.

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

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

Hi folks,

which is a
date field. I can't control the date field:

field1 - WD101
character - /
date - 01-Nov-03