OnDemand User Group

Support Forums => Report Indexing => Topic started by: JimWilson on January 10, 2007, 05:59:45 AM

Title: Date Formats
Post by: JimWilson 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?
Title: Re: Date Formats
Post by: Carol Allen 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.