Date Format (1 Viewer)

[gsrajan]

Please let me know how to convert a date format from 6/11/2020 to June, 11, 2020 in a text box field in a form and also it get saved in the table in the same format. Thanks for your help.

 

[theDBguy]

Hi. Formatting is separate from the value. I suggest you format the value for display, but store it as the actual value. You could try something like this:

Format([DateField], "mmmm, dd, yyyy")

 

[Micron]

No code needed if you simply use the textbox format on the property sheet - Long Date
I guess that depends on whether or not the example you posted matches your regional settings.

 

[gsrajan]

Thank you all. Format([DateField], "mmmm, dd, yyyy") is fine with me. It works. Thanks.

 

[theDBguy]

Thank you all. Format([DateField], "mmmm, dd, yyyy") is fine with me. It works. Thanks.

Hi. You're welcome. Glad we could assist. Good luck with your project.

 

[gsrajan]

Thanks.