Date format in string
="Week Beginning " & text(TODAY()-WEEKDAY(TODAY(),3),"dd mmm yyyy")
--
HTH
Bob Phillips
(remove xxx from email address if mailing direct)
"Adam Thwaites" wrote in message
...
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
Manchester, UK
|