Date Function

[Heavenly Hash]

Concerning the date diff function, how will i'll be able to display January
instead of the number 1?

 

[Rick Brandt]

Concerning the date diff function, how will i'll be able to display
January instead of the number 1?

DateDiff() returns an Integer representing how many of the chosen interval
exist between two dates that you feed in as arguments. How exactly does
getting "January" make sense in that context?

 

[Duane Hookom]

How does displaying "January" relate to DateDiff()? The function returns the
number of seconds, minutes, hours,...months, years between two date values.

If you have a field or expression with the value 1 and you want to display
this as January, you can use
MonthName([YourFieldOrExpression])
or
Format(DateSerial(2000,[YourFieldOrExpression],1),"mmmm")

 

[Heavenly Hash]

Is there a way that i can possibly send you my database, so that u can
actually see what i'm trying to accomplish ??

This is directed at Duane Hookom

Thank you very much in advance

 

[Duane Hookom]

no.

Figure out:
- what you have,
- what you need,
- how to ask so that we can understand

That's how newsgroups work.

Receiving and opening attached databases is often based on a fee structure.
I would prefer to not go there after only a couple messages in a thread.

 

[Chris]

Hi

Have a look at this website:www.accessvba.com
It's a very good forum not only allowing you to ask and answer questions,
but also to send your files( which you should zip) for others to look at and
help. You have to register but that is free and you get email notification
when someone answers your question.

Good luck

Chris