The datefields in our database are in yyyymmdd format. I have a formula field that converts to mm/dd/yyyy (date(val(left(totext({TXPYMT.PYMTDATE},0,""),4)),val(mid(totext({TXPYMT.PYMTDATE},0,""),5,2)),val(mid(totext({TXPYMT.PYMTDATE},0,""),7,2)))
I also have another formula field that adds the weekday to the above formula field (WeekdayName (DayOfWeek({@PaymentDate}))& ", "& {@PaymentDate})
I want to sort the field with the weekday by the date. I have my sort assending by the PYMTDATE field, but when I refresh the report, the date is sorted by the weekday instead. How can I sort by the date??
I also have another formula field that adds the weekday to the above formula field (WeekdayName (DayOfWeek({@PaymentDate}))& ", "& {@PaymentDate})
I want to sort the field with the weekday by the date. I have my sort assending by the PYMTDATE field, but when I refresh the report, the date is sorted by the weekday instead. How can I sort by the date??