DateDiff Error! Wrong Number of argument

News Central

To all!
I use the DateDiff function using VB6 and get this error 'Wrong number of
argument or invalid property assignment' ... have anyone seen this problem?
thanks ....

Jul 17 '05 #1

Subscribe Post Reply

7127

Bob Butler

"News Central" <Ba*@Bay.com> wrote in message news:<Ya********************@baytsp.com>...

To all!
I use the DateDiff function using VB6 and get this error 'Wrong number of
argument or invalid property assignment' ... have anyone seen this problem?
thanks ....

No. Post your code.

Do you have something else named 'DateDiff'? (right click on the
function name in your code and select 'Definition' to see if it takes
you somewhere unexpected).

When you enter DateDiff( what does intellisense show?

Does using VBA.DateDiff work?

Jul 17 '05 #2

News Central

you're right, somewhere in my codes, there is a function called DateDiff....
:> thankls
"Bob Butler" <bu*******@earthlink.net> wrote in message
news:fa*************************@posting.google.co m...

"News Central" <Ba*@Bay.com> wrote in message

news:<Ya********************@baytsp.com>...

To all!
I use the DateDiff function using VB6 and get this error 'Wrong number of argument or invalid property assignment' ... have anyone seen this problem? thanks ....

No. Post your code.

Do you have something else named 'DateDiff'? (right click on the
function name in your code and select 'Definition' to see if it takes
you somewhere unexpected).

When you enter DateDiff( what does intellisense show?

Does using VBA.DateDiff work?

Jul 17 '05 #3

Similar topics

DateDiff problem on different servers

by: CJM | last post by:

I have an ASP page that lists files and folders in a directory. I'm using a cookie to record the last time this page was visited, and I intend to show links that are created/modified from that date...

ASP / Active Server Pages

ASP DateDiff

by: inamori | last post by:

I face that problems 07/01/2003 06/30/2006 ---------> it should be 3 01/01/2003 02/28/2005 --------->could i get 2 years and 2 months 01/01/2003 03/01/2005 ...

ASP / Active Server Pages

DateDiff

by: Lofty | last post by:

Hi all. I have to write an app that interacts with mySQL (I really must have done some evil, evil stuff in a previous life to be landed with this!) I need to work out the difference in days...

MySQL Database

Working with time (dateDiff)

by: John Smith | last post by:

Hi, I'm having trouble working out the best way of calculating the time difference between two times on the same day. The example I have found does return the hours (in this case 8) but forgets...

ASP / Active Server Pages

Datediff

by: T23Ij9 | last post by:

Hi. I have 3 seperate date fields. InitialDate InspDate ReportDate I am trying to setup several unbound Text boxes in a form that will give me days elapsed between these dates. These text...

Microsoft Access / VBA

Calculate age / age next birthday from date of birth without using DateDiff solution

by: Adrian | last post by:

I hit on this problem converting a VB.NET insurance application to C#. Age next birthday calculated from date of birth is often needed in insurance premium calculations. Originally done using...

C# / C Sharp

Datediff not including weekday?????

by: kevinjwilson | last post by:

I am trying to get the date difference between two dates but I don't want the function to include weekends in the calculation. Does anyone have an idea on how to make this work?

Microsoft Access / VBA

Sql query datediff syntax error

by: KA NMC | last post by:

I know this is very simple...but the syntax is really screwing me up...Basically what I want to do is have this query check for orders that have been open two hours and more and does not have a...

Microsoft SQL Server

DateDiff() quick question

by: Brita | last post by:

You guys have been life savers for me, and I appreciate your help so much. I am trying to check the difference in days between two submitted requests. DateFormat df =...

Java

correct the datediff function

by: muddasirmunir | last post by:

i am using vb 6 , i had place two datepicker in form now i want to calcuate differcen of month in two date for this i used the function datediff i had try it withh many syntax but getting error...

Visual Basic 4 / 5 / 6

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++