DOB to print 01/01/xx on report

[Guest]

I have a report with employees date of birth and need to "X" out the year
when printing. Can someone help ??

Thanks!

 

[SA]

Tina:

You can in your report's query alias the dob field and use the format
function to format the dob as you desire like this:

DOB: format([YourDOBFieldName],"mm/dd/xx")

Note that if your table field is DOB, then you have to use a different alias
name such as DOBMasked:

 

[John Spencer]

Use the format function and format the control as "mm/dd"
If you require x's for the year then try "mm/dd/xxxx"