Dates

[Fie]

Hi,

what is the code you enter in to query to seperate the dates stored in
databaseup into day, month, year...?? I know it displays the months are
1,2,3,4 etc but is there anyway that it can display them as Actual
month names in a report????

fiona

 

[Guest]

Try

Year([DateField]) will return the year
Month([DateField]) will return the month number
Day([DateField]) will return the day number

To get the month name, try
Format([DateField],"mmmm")

 

[Fie]

when i type in

Year([Weekending]) will return the year
Month([Weekending]) will return the month number
Day([Weekending]) will return the day number

it returns the weekending date in all 3 fields....

and where do i but Format([DateField],"mmmm") in the report???

 

[Fie]

ooops... iv got it to work sorry... had spelling mistakes

cheers x