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’
Visit the AnswerBook to Learn More
Have any other tips for working with data from the CUFMAINT file? We’d love to hear from you – email Asterisk Intelligence at ai@cuanswers.com