I have a report that includes a date parameter (equal to ot greater than) that won't return data that has a date in next year (2012). I did not create this but the end users tell me that this happens every December and that the previous consultant would tweak it and they'ld be good for the next 12 months. I would appreciate any guidance and I thank you in advance.

 

Skip

 

This report lists orders by their arrival date. This data is stored in a udf. The formula to re-arrange the format looks like this (12/13/110

if length ({tsoSalesOrder.userFld1}) = 10
then {tsoSalesOrder.userFld1}[6 to 7]+ "/" + {tsoSalesOrder.userFld1}[9 to 10] + "/" + {tsoSalesOrder.userFld1}[3 to 4]
else {tsoSalesOrder.userFld1}

 

Thanks,

 

Skip