Date fuction in Excel 2000

Q · May 13th, 2002, 08:20 AM

I've developed a spreadsheet on a WindowsXpOfficeXP platform.
The platform it is being used on is NT4Office2K. (I know, I know....I like to develop on the same platform that it will be used on too, but I didn't have an extra computer to install the platform on.)
The problem is the DATE function in VB. On WinXPOffXP it works fine, but I get a compile error on the DATE on NTWin2K. Can someone please tell me the function for current date in Off2K.

[ This Message was edited by: Q on 2002-05-13 07:21 ]

Ivan F Moala · May 13th, 2002, 08:27 AM

Quote:

On 2002-05-13 07:20, Q wrote:
I've developed a spreadsheet on a WindowsXpOfficeXP platform.
The platform it is being used on is NT4Office2K. (I know, I know....I like to develop on the same platform that it will be used on too, but I didn't have an extra computer to install the platform on.)
The problem is the DATE function in VB. On WinXPOffXP it works fine, but I get a compile error on the DATE on NTWin2K. Can someone please tell me the function for current date in Off2K.

[ This Message was edited by: Q on 2002-05-13 07:21 ]

The Date Function should operate the same ?
How have you coded it and what is the Error
You say you are getting a compile error
have you got all your references right ?

Q · May 13th, 2002, 08:32 AM

Ivan,
Thanks for the speedy response. The code is for a command button that brings up a calendar (using a calendar control) on a userform. The line is just to default the date to the current date when it is accessed.

frmInput.Show
frmInput.calInput.Value = DATE

As for the specific error I have asked to have a screenshot sent to me, I am waiting on it.

[ This Message was edited by: Q on 2002-05-13 07:34 ]

Ivan F Moala · May 13th, 2002, 08:43 AM

Quote:

On 2002-05-13 07:32, Q wrote:
Ivan,
Thanks for the speedy response. The code is for a command button that brings up a calendar (using a calendar control) on a userform. The line is just to default the date to the current date when it is accessed.

frmInput.Show
frmInput.calInput.Value = DATE

As for the specific error I have asked to have a screenshot sent to me, I am waiting on it.

[ This Message was edited by: Q on 2002-05-13 07:34 ]

I suspect you have a missing reference.
probably for the calendar control ocx ?
But this is a guess.

Q · May 13th, 2002, 08:49 AM

Thanks, It's a place to start looking.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 13th, 2002, 08:20 AM	#1
Q Board Regular Join Date: Apr 2002 Location: 20 Minutes outside Manhattan Posts: 64	I've developed a spreadsheet on a WindowsXpOfficeXP platform. The platform it is being used on is NT4Office2K. (I know, I know....I like to develop on the same platform that it will be used on too, but I didn't have an extra computer to install the platform on.) The problem is the DATE function in VB. On WinXPOffXP it works fine, but I get a compile error on the DATE on NTWin2K. Can someone please tell me the function for current date in Off2K. [ This Message was edited by: Q on 2002-05-13 07:21 ]

May 13th, 2002, 08:32 AM	#3
Q Board Regular Join Date: Apr 2002 Location: 20 Minutes outside Manhattan Posts: 64	Ivan, Thanks for the speedy response. The code is for a command button that brings up a calendar (using a calendar control) on a userform. The line is just to default the date to the current date when it is accessed. frmInput.Show frmInput.calInput.Value = DATE As for the specific error I have asked to have a screenshot sent to me, I am waiting on it. [ This Message was edited by: Q on 2002-05-13 07:34 ]

May 13th, 2002, 08:49 AM	#5
Q Board Regular Join Date: Apr 2002 Location: 20 Minutes outside Manhattan Posts: 64	Thanks, It's a place to start looking.