Author Topic: Date Formats  (Read 3697 times)

JimWilson

  • Guest
Date Formats
« on: January 10, 2007, 05:59:45 AM »
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

  • Guest
Re: Date Formats
« Reply #1 on: April 16, 2007, 02:29:14 PM »
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.