Masking in Notes

How to do Masking in a date field in Notes? I want to have a field(text type) so that date format can be accepted in DD/MM/YYYY format. But I want to protect the 3rd and 6th Positions of the field so that the user cannot enter anything in this position(I want to put a slash seperator later). How do I do this? i do'nt want to create seperate fields for DD,MM,YY.  
vsprakashAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

sk5tCommented:
Input Translation at the field level will do the trick -- the rigorous approach, independent of regional/date settings (to enforce DD/MM/YYYY specifically, in a text field, with the slashes explicitly):

@Text(@Day(@TextToTime(Fieldname)))+ "/" + @Text(@Month(@TextToTime(FieldName))) + "/" + @Text(@Year(@TextToTime(Fieldname)))

Of course, controlling the field is much easier if it is of datatype date, or you accept some of the format-strings in @Text().  And you will probably want to add Input Validation for error trapping.
0
vsprakashAuthor Commented:
I do'nt want to do concat on this field. Iam just trying to findout if there is an easy way out to Mask
0
sk5tCommented:
It isn't a cat operation at all.  Input translation entirely resets the value of the field as it is exited or refreshed.  

Notes is not Access.  There are ways to accomplish essentially the same thing as masking, via input translation and input validation field events as I have described above,
0
Exploring SQL Server 2016: Fundamentals

Learn the fundamentals of Microsoft SQL Server, a relational database management system that stores and retrieves data when requested by other software applications.

jschwarzCommented:
I think this question deserves a few more points.  But I'll answer anyway.

You can do a pattern match with:
  @Matches(DateField ;"??/??/????")

That will return true or false regarding the length of DateField and regarding the 3th & 6th characters.

Then, test the rest of the characters for numbers with this:
  @IsNumber(@Left(DateField; 2))
  @IsNumber(@Right(@Left(DateField;5);2)
  @IsNumber(@Right(DateField; 4))

Finally, you can test for values in the normal way (i.e., @If(@Left(DateField; 2) < 13 & > 0)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sk5tCommented:
That's a fair enough approach for input validation... nothing like masking, though.  At any rate, it's unlikely to satisfy the question's author, who seems to be looking for some magic bullet without a clear understanding of Notes' events.
0
jschwarzCommented:
sk5t, could you clarify?  Maybe a better understanding of what masking is would help me.  I thought what I supplied was pretty much what he was requesting.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.