I have the following field <Transaction_Date> which looks like 08/06/2003. I created a variable in my report called varTransMonth
=FormatDate(<Transaction Date> ,"Mmm yyyy"
When I use this in a cross tab the dates do not sort properly? They appear to be in alphabetical order, I have tried custom sorting by using the month option and that does not work either. Any ideas on how to get this to work?
Thanks Much!!
=FormatDate(<Transaction Date> ,"Mmm yyyy"
When I use this in a cross tab the dates do not sort properly? They appear to be in alphabetical order, I have tried custom sorting by using the month option and that does not work either. Any ideas on how to get this to work?
Thanks Much!!