Format Date

[GloriaLuz]

Hello,
This is problably a very simple question; however, I can't find the way to do it.

I have a field in a form that its default value is today's date: Default value: Date().

As you know, it always appears as dd/mm/yyyy. Is there a way to change it and instead to appear as mm/dd/yyyy ? I am sending this field to some reports and an error is appearing as in the database dates are stored as mm/dd/yyyy

Thank you!

 

[gromit]

Hi Gloria -

Right click the field and choose Properties. Look for the "Format" tab. On the format tab, the first item should be "Format" (again). Type whatever format you want in the field

I.e.
mm/dd/yyyy
dd/mm/yyyy
yyyy/mm/dd

Hope that helps,

-g

 

[GloriaLuz]

Hello gromit,

I tried as you suggested and it almost worked but it sent me an error at the end and instead of getting the date I got "mm/dd/yyyy" however, I continued trying and found out that I needed to change in the properties of the text box the Default value and put =Format(Date(),"mm\/dd\/yyyy")

It finally worked.
Thank you!