Date Formats

Previous topic - Next topic

JimWilson

Does anyone know the difference between
%f%e%y = 1/31/07 and %m%d%y = 01/31/07
What if I use the %f%e%y to index a new report starting with January
What will happen when it gets to October?

Carol Allen

It will work fine in October.  I just tried several variations, and got the same result with both %f/%e/%y and %m/%d/%y for reports with dates of 2/ 9/90 and 12/19/90.  But make SURE that you remove embedded, leading, and trailing spaces for the date in the Load tab of the Application.  Just to be safe in case you do get a date with a space where a zero should be.