Problem with the Format Function

[BAWC01]

Hi

I am trying to format a date, using a wrapper function

Public Function SetInvDate() As Date
SetInvDate = format(GlobalInvoiceDate, "dd-mm-yy")
End Function

But I have noticed that the format stays in lower case and in black, rather than like Format in uppercase.

What is going on

Phil

 

[avolkert]

What is "GlobalInvoiceDate" ? Is it a Date Value or a text string ?

 

[Zion7]

lower case and in black???

like avolkert said, If GlobalInvoiceDate is a Date data type, then I would expect 2/24/05 to look like 24-02-05?

Where would you get any text from, and what has forecolor got to do with it?

In other words, "what data type is GlobalInvoiceDate", and what results are you expecting?

 

[JerryKlmns]

I think that what Phil says is that this line
SetInvDate = format(GlobalInvoiceDate, "dd-mm-yy")
should look like
SetInvDate = [blue]Format[/blue](GlobalInvoiceDate, "dd-mm-yy")

 

[SimonSellick]

I think the issue is that your function returns a date, not a string. No matter how you format the string within the function, it will still come out converted to a date. Did you mean:

Public Function SetInvDate() As String
  SetInvDate = format(GlobalInvoiceDate, "dd-mm-yy")
End Function

?

 

[RoyVidar]

If JerryKlmns is correct, then you most likely you have an object, variable, form control ... somewhere within the scope you're programming in, which is named like that. Find that, and rename it, else you're going to have further challenges. You can probably circumvent some of the challenges by prefixing with the library (VBA.Format( ...), but again, renaming the offending "thingie" is probably best.

Roy-Vidar

 

[TheAceMan1]

How are ya BAWC01 . . .

In the immediate window type . . .

[blue]? SetInvDate() [/blue]

. . . and hit enter. [blue]This will reveal the format of the date returned by the function.[/blue] From here you shohld be able to tell if its a problem in the function, or a problem in the object the function value is assigned to . . .

See Ya! . . . . . .