Date in two different formats

[mlkshake]

Hello There,



I would like to display two date formats in two seperate text fields using VBA.


MM-DD-YYYY source from a text field named Appdate with =Date() as the standard value.


DD.MM.YYYY source from a text field named Appdate with =Date() as the standard value.


Any ideas on how I can get dates in the above mentioned values ?

[xps35]

Use the Format function:

Format(Appdate ,"mm/dd/yyyy")
Format(Appdate ,"dd\.mm\.yyyy")

[mlkshake]

Thank you for the quick reply, and for the solution!

[mlkshake]

One question though, how can I make the same formats send the date formats to another form

ie. Forms!appointment!Format(Appdate, "mm/dd/yyyy")

[Edgar]

Try:

Format(Forms!appointment!Appdate.Value, "mm/dd/yyyy")
       ^-----------------------------^  ^----------^
                  REFERENCE                FORMAT

The Format function requires an input and a format, for input, use the value reference, for format, use what you have.

[June7]

Why would you need VBA for this? Do calc in query or textbox.