Date and time formatting when pulling from a form field

[avarusbrightfyre]

I'm creating automatic email messages and I'm pulling date and time from forms on the field, but the formatted date and time aren't transferring from the field, through the code and into the email. Is there a way to format a date or time field while pulling from a text box on a form using vba?

[June7]

Try the Format function. The result is a string value. Maybe that will hold the structure.

[pdebaets]

Agree with June7. Here's an example:

Format(MyDateField,"yyyy mm dd")

[avarusbrightfyre]

Man do I feel dumb. I saw that when I googled, but somehow I just formatted it wrong. Thanks!