Dates (again) Access 2

[santastefano]

I am trying to run either of the following lines.
varBegin = Weekday(Date, Forms!frmCourseStart!StartDate)
varBegin = DatePart(d, Forms!frmCourseStart!StartDate)

varBegin is a declared variable
Forms!frmCourse!StartDate is a user input date on a form which is open when this runs (format dd/mm/yyyy.

Both return the error message invalid procedure call or argument.

I have searched here, the Access 2000 book and MSDN and can not find a solution.
Can anybody please help?

 

[PHV]

varBegin = Weekday(Forms!frmCourseStart!StartDate)
varBegin = DatePart("d", Forms!frmCourseStart!StartDate)


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[SkipVought]

is this a REAL DATE ???

or is it a STRING that looks like a date???

Forms!frmCourseStart!StartDate

You may ave to convert your string to a real date via the DateSerial Function

varBegin = Weekday(Date, DateSerial(YearFromString,MonthFromString,DayFromString)

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[santastefano]

10,000 thank yous'

 

[PHV]

Skip, in which version of VBA is your posted Weekday function running without trouble ?

 

[SkipVought]

PHV,

he he, er, uh...

I completely missed the TWO ARGUMENT issue.

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}