How can I combine two text fields and format as a date?

[accessmatt]

Hello, how can I combine two text fields and format them as a date.



Text Field 1: Jan
Text Field 2: 2014

Desired Output Jan-2014 (being an actual date field)

[June7]

[Field1] & "-" & [Field2]

The result will be a string, not a true date. If you need a true date then won't look like that.

DateSerial([field2],[field1],1)

[accessmatt]

Thanks June7, I've tried Date Serial but it's requiring that I put a "day" field in which I presume is the "1" in your example. Doing that through an #Error in the output though. Any thoughts?

[June7]

Ooops, DateSerial() doesn't recognize the alpha month. Try:

CDate(Field1 & "/1/" & Field2)

However, that will error if any field is Null.