format a date

[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

 

[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

This is a Date datatype field?

Set the format property of the control to
mmmm

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

 

[Rodolfo Fontes]

Thanks,
It solved my problem.

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

This is a Date datatype field?

Set the format property of the control to
mmmm

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