Input Mask

[superrob5]

I want to be able to enter
either
516-222-1111,____
___-___-1111,____
516-222-1111,3333

as the input mask for phone numbers what would be the format???? I tried a couple different ways but its not working

 

[Fizzio]

either
999-999-9999,9999;0;"_" if no characters are mandatory

999-999-0000,9999;0;"_" if the 3rd set of nos are required.

hth

 

[superrob5]

kool thanks is it the same way if I want 2 have 2 dates in a field I will try it when I get home but was getting errors.

 

[Fizzio]

Why do you want to have 2 dates in a field - not a good idea. Store the 2 dates in separate fields.

 

[superrob5]

this is becasue based on someones excel spreadsheet and they want this, I might do it the other way but how do I do this??

 

[Fizzio]

If you are importing from an excel spreadsheet, this will be a little more tricky but if you are inputting the data, just set up a field for each date. Db fields are designed to store 1 piece of information and 2 dates is strictly classed as 2 separate pieces of info. If you ever need to do analysis on these dates, it will be nigh impossible if they are both in the one field.