Go Premium for a chance to win a PS4. Enter to Win

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

Customize input mask for date field

I have a table that I have linked to a table.  I want the date field to display the date as "mmm, yy" i( Jan 06) instead of the short date (01/01/2006).

How can i do this?

Any help is appreciated.

Arethea
0
lynnell35
Asked:
lynnell35
  • 3
  • 2
  • 2
1 Solution
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
You can't change the table schema of a linked table, only at the source table.

You can change the way it appears in forms by editing the Format property of a control that is bound to your date field.

-Jim
0
 
lynnell35Author Commented:
How would i do this?

0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Where are you at with this right now?
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
rockiroadsCommented:
As Jim says, u can modify the field on a form

If u open a form, go in design view, select your field and look at its properties
there is one called Format

u can pick a predefined one or make your own

e.g. a format specified like this

mmm", "yy


will display Jan, 06

Bear in mind though, if this field is editable, then u will lose this format when that field gets focus. but reverts back when u lose focus


0
 
rockiroadsCommented:
thanks lynnell35
I wonder though if some credit should go to Jim since he suggested u use the format property
0
 
lynnell35Author Commented:
Yes, thanks you.  I would like to split the points between the both of you.   Sorry Jim, when i finally got around to opening this message i was in such a rush that just saw the code and clicked accept.

Once again thanks for all of your help.  I don't know what i would do with out you gusy.



0
 
rockiroadsCommented:
Raise a question in community support asking them to reopen this so u can award points accordingly
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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