Converting Date & Time into a Month

  • Thread starter Thread starter HL
  • Start date Start date

HL

Registered User.
Local time
Today, 16:50
Joined
Feb 13, 2001
Messages
19
Please Help!!!!!!!

I have created a database which works on information for a month, then at the end of the month it is transferred to a history table.

What I like to happen in the header of the form is to have a text box which will covert the first date which is entered into the table for example (02/02/2001 09:55:00) into a month

So for example the text box in the will say = "Total Number of Faults For The Month of " & [ Month]

The only problem I have is that I cannot change the Date / Time format because it is working out downtime between two dates & times

How do I convert it and where do I put the conversion?????

Thanks

HL
 
This ought to work:

= "Total Number of Faults For The Month of " & Format([YourDateFieldName],"mmmm")

HTH

Mike
 

Users who are viewing this thread

Back
Top Bottom