Quick Tip for Report Writers – Use the Better Date from CUFMAINT

Save time, simplify your work, and stop typing your dates in both the YYMMDD and MMDDYY layouts each time you run a query over the File Maintenance data. The original Maintenance Date field of MNTDAT will naturally have dates in both layouts, which is friendliest for optimal processing by the programs that write out the maintenance records. But, having both layouts adds complexity to data mining for your report-writing and analysis projects.

Adjust your queries to instead use a different date field available in the File Maintenance data (CUFMAINT in FILExx). This one standardizes the layout and is defined as an ISO date field so that calculations and custom fields can be used with this date:

Activity Date – MNLSTUPDDT


Instead of setting up your date filters like this:

MNTDAT equals a value in the list 052819 190528


Change it to use this instead:

MNLSTUPDDT equal to ‘2019-05-28’


Do you have any other tips for working with data from the CUFMAINT file? It’s a popular one! We’d love to hear from you!


Leave a Reply

Your email address will not be published. Required fields are marked *