Date format in string

[Adam Thwaites]

I have this code:
="Week Beginning " & Date-WEEKDAY(Date,3)
which I can't stop coming out as:
Week Beginning 38719

I tried:
="Week Beginning " & format((Date-WEEKDAY(Date,3)),"dd" & "/" & "mm" & "/" &
"yyyy")
but that just comes up as #NAME

Any suggestions?
--
Adam Thwaites
Access Database Designer
adam.*spamless*[email protected]
Manchester, UK

[Bob Phillips]

="Week Beginning " & text(TODAY()-WEEKDAY(TODAY(),3),"dd mmm yyyy")


--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Adam Thwaites" <[email protected]> wrote in message
news:[email protected]...
> I have this code:
> ="Week Beginning " & Date-WEEKDAY(Date,3)
> which I can't stop coming out as:
> Week Beginning 38719
>
> I tried:
> ="Week Beginning " & format((Date-WEEKDAY(Date,3)),"dd" & "/" & "mm" & "/"
&
> "yyyy")
> but that just comes up as #NAME
>
> Any suggestions?
> --
> Adam Thwaites
> Access Database Designer
> adam.*spamless*[email protected]
> Manchester, UK

[Gary''s Student]

Consider using TEXT():


="Week Beginning: " & TEXT(TODAY()+4,"dd/mm/yyy")
will display as:
Week Beginning: 14/05/2006

--
Gary''s Student


"Adam Thwaites" wrote:

> I have this code:
> ="Week Beginning " & Date-WEEKDAY(Date,3)
> which I can't stop coming out as:
> Week Beginning 38719
>
> I tried:
> ="Week Beginning " & format((Date-WEEKDAY(Date,3)),"dd" & "/" & "mm" & "/" &
> "yyyy")
> but that just comes up as #NAME
>
> Any suggestions?
> --
> Adam Thwaites
> Access Database Designer
> adam.*spamless*[email protected]
> Manchester, UK

[JE McGimpsey]

One way:

="Week Beginning" & TEXT(Date-WEEKDAY(Date, 3), "dd/mm/yyyy")


In article <[email protected]>,
Adam Thwaites <[email protected]> wrote:

> I have this code:
> ="Week Beginning " & Date-WEEKDAY(Date,3)
> which I can't stop coming out as:
> Week Beginning 38719
>
> I tried:
> ="Week Beginning " & format((Date-WEEKDAY(Date,3)),"dd" & "/" & "mm" & "/" &
> "yyyy")
> but that just comes up as #NAME
>
> Any suggestions?