Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 9087
  • Last Modified:

How format date field to show month and year only

I have a date field in a table and then on a form.  But we want the field to display only the month and year.

Like:  06/2014 for example.

How can I do that?
0
SteveL13
Asked:
SteveL13
  • 2
1 Solution
 
Rey Obrero (Capricorn1)Commented:
format([DateField],"mm/yyyy")
0
 
SteveL13Author Commented:
Where do I put that?  P pasted it in the format line in the field properties and it turned out like:  "for"m"at([Pur"ch\as\ed"ate],mm/yyyy)"
0
 
SteveL13Author Commented:
Thoughts?
0
 
Gustav BrockCIOCommented:
Don't use the Format function, just set the Format property of the textbox in the form.

Currently, it probably is set to Standard. Change that to: mm/yyyy

/gustav
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now