Concatenate Date + String

[#1]

Hi there - I have three fields I am working with:

Field	Example Date
Date	2/4/2014
Week Type	Off
Week Number	1

I'd like to show all three together like this: "Feb 4-Off-1"

When I use [Date]&'-'&[Week Type]&'-'&[Week Number] I get "41674-Off-1"

How do I keep or change the date formula to display properly?

Thanks!

[MarcoWedel · Accepted solution]

Date(Date,'MMM D')&'-'&[Week Type]&'-'&[Week Number]

[sunny_talwar]

Try this:

Date(Date, 'MMM D')&'-'&[Week Type]&'-'&[Week Number]

[Anonymous]

Hope this helps

Month([Date])&'  '& Day([Date]) &'-'&[Week Type]&'-'&[Week Number]

[#5]

Thank you!