asked on

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.

sk5t

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.

vsprakash

ASKER

I do'nt want to do concat on this field. Iam just trying to findout if there is an easy way out to Mask

sk5t

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,

ASKER CERTIFIED SOLUTION

jschwarz

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

sk5t

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.

jschwarz

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.