DateDiff between a field and now

[julie417]

Hello,

I would like to count the days between [InvoiceDate] and Now, but I keep getting messages that either I have the wrong number of arguments or I am missing brackets/parenthesis/vertical bar.

Can someone help me write this expression????

Thanks!!

 

[Brianwarnock]

Use Date() not Now() as you don't need the time element.
Why not post what you have tried

Brian

 

[eliW]

Hello,

I would like to count the days between [InvoiceDate] and Now, but I keep getting messages that either I have the wrong number of arguments or I am missing brackets/parenthesis/vertical bar.

Can someone help me write this expression????

Thanks!!

Hi
Try: Expr1: Date() - [InvoiceDate]
Eli

 

[julie417]

Use Date() not Now() as you don't need the time element.
Why not post what you have tried

Brian

Brian - Next time I will keep track of what I tried. I tried so many I couldn't tell you!

 

[julie417]

Hi
Try: Expr1: Date() - [InvoiceDate]
Eli

Thanks Eli.....this worked perfectly!

 

[Brianwarnock]

Brian - Next time I will keep track of what I tried. I tried so many I couldn't tell you!

The syntax of the Datediff is simple, I wanted to see where your problem was I order to help you for the future, it is too easy for us to give the correct answer and for the poster to learn nothing in such circumstances.


Brian

 

[eliW]

The syntax of the Datediff is simple, I wanted to see where your problem was I order to help you for the future, it is too easy for us to give the correct answer and for the poster to learn nothing in such circumstances.

Brian

Hello Brian,
With all the respect : Why do you think that giving the correct answer teaches nothing? From my experience in Excel I've found that going slowly step by step will make you an expert after a few thousands of these steps…​

Take for example my first question in this forum: http://www.access-programmers.co.uk/forums/showthread.php?t=252239 . I asked there a very simple and most defined question. For me as a newbie it was very important to learn to do the little first step of an infant, and I meant to have a direct answer to what concerned me. Now what did I get as an answer? Listen:

First, why? I understand reinventing the wheel to help you learn how the wheel works. Yet, here you are asking us for help instead breaking it down yourself. Why?

It seems that some of you people in this forum are trying to EDUCATE instead of TEACHING and that's pity.Having no other choice, I became now a member of another Access forum (BTW American one) and I am finding there much of the TEACHING attitude rather than the EDUCATING one and I am very satisfied.​

I hope that you –the experts of this forum – will be more concerned to the true needs of the posters and make this forum much more friendly.​

Best wishes,

​

Eli​

 

[Brianwarnock]

I'm sorry but the subtle difference between educating and teaching eludes me. We aim on here to educate by teaching posters to learn the full facts, it is all too easy to give a simple answer which leaves the poster with the answer to today's question but ill equipped to deal with tomorrow's .

Whilst your original answer works for the number of days it does not teach Julie anything about DateDiff and educate her on its use ie overcome whatever her problem was, thus if she needs to calculate the number of hours between two date/time fields she may still have problems.

Brian

 

[Brianwarnock]

Having followed your link I can understand how you felt after that first post, some responders do get carried away with themselves, I certainly did not understand the response.

I would have said that if you have a date you can format the display of that date in numerous ways with the Format function one of which is
Format(datefield,"dddd") to display the day.
Read about Format either in help or via google to see other options.

Julie
Sorry to hijacked your thread.

Brian

 

[eliW]

Brian,
Thank you for your understanding, it gives me another view of this forum.
And another big appology for Julie for using her thread as a platform for philosophical thoughts.
Eli