Help with function

[traycee]

I'm sure it's something simple that I am just missing. The following line is erroring on Program Admission Date

Function YearMonthDate([Program Admission Date] As Date, [Date Discharged], As Date) As String

What am I missing in the syntax.

 

[PHV]

I'd suggest this:
Function YearMonthDate(ProgramAdmissionDate As Date, DateDischarged As Date) As String

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

 

[traycee]

That doesn't quite work. I didn't write this database. The fields I'm identifying actually have spaces between them. i.e. Program Admission Date and Date Discharged. I thought brackets around the field names would work, but of course they didn't. Any thoughts.

 

[dmksas]

Traycee,

The function will take parameters not table fields.

Could you post some more of the function so we can establish what is trying to be achieved.

Danny

Never Think Impossible

 

[traycee]

Thanks...I figured it out and am not getting the correct output.