Hard Coded Characters

[Hue]

hard coded chars.. how?

let's say the field is date.... the format is mm-dd-yyyy
now how can i make my field on that table so that i won't be typing dashes(-) anymore because it's hard coded.

 

[WayneRyan]

Hue,

Keep your field as a date. You can choose the Short Date
format in your tables design.

Wayne

 

[Hue]

hi wayne,

thanks for the quick reply. what i did is i made a custom FORMAT which is mm-dd-yyyy, i can't use short date becase the format is mm/dd/yyyy.

it's all in the input mask. but can't figure it out. i was able to hard code dashes(-) but i was prompted: THE VALUE YOU ENTERED ISN'T VALID FOR THIS FIELD

what's wrong with this paramaters:

FORMAT: mm-dd-yyyy
INPUT MASK: 99\-99\-0000 <-- my first try
99"-"99"-"0000 <--- my second try

still not working

 

[Hue]

ahhh.... now it's working.

input mask is 99-99-0000

before when type 99-99-0000 it will automatically include backslah(\).. now not anymore. WEIRD!