format a date

R

Rodolfo Fontes

Hi Group,

How To format a field to list the month?
Where the field "mes" is like a number, i want to set it like: June, July...
etc.
If someone have any site to colect this kind of information, i would
appreciate a lot!
How can i do that?
For example:

Query1 Data Emissão ContarDePart#F mes
13/05/04 5 5
14/05/04 16 5
17/07/04 2 7
18/08/04 2 8
19/09/04 2 9
20/09/04 1 9



Thanks,
Rodolfo Fontes
 
F

fredg

Hi Group,

How To format a field to list the month?
Where the field "mes" is like a number, i want to set it like: June, July...
etc.
If someone have any site to colect this kind of information, i would
appreciate a lot!
How can i do that?
For example:

Query1 Data Emiss¿~ ContarDePart#F mes
13/05/04 5 5
14/05/04 16 5
17/07/04 2 7
18/08/04 2 8
19/09/04 2 9
20/09/04 1 9

Thanks,
Rodolfo Fontes
Click to expand...

This is a Date datatype field?

Set the format property of the control to
mmmm

Or use
=Format([DateField],"mmmm")
 
R

Rodolfo Fontes

Thanks,
It solved my problem.

fredg said:
Hi Group,

How To format a field to list the month?
Where the field "mes" is like a number, i want to set it like: June, July...
etc.
If someone have any site to colect this kind of information, i would
appreciate a lot!
How can i do that?
For example:

Query1 Data Emiss¿~ ContarDePart#F mes
13/05/04 5 5
14/05/04 16 5
17/07/04 2 7
18/08/04 2 8
19/09/04 2 9
20/09/04 1 9

Thanks,
Rodolfo Fontes
Click to expand...

This is a Date datatype field?

Set the format property of the control to
mmmm

Or use
=Format([DateField],"mmmm")
Click to expand...
 
Top