Results 1 to 5 of 5

Thread: tricky formating question

Threaded View

  1. Nov 27th, 2006, 10:41 AM #1
    waely
    waely is offline

    Thread Starter
    Addicted Member
    Join Date
    Nov 2002
    Posts
    150

    tricky formating question

    hi,
    I have tricky question and I hope someone has an idea.
    I have a report that has dates and formula for MaxDate. the dates should be sorted Asc. if the dates are null then I want them to show at the buttom so what I did is replaced the null value with 1-1-2070 so when sorted it will be at the buttom then hid it. this works good as for sorting but when I do the max it will use the 1-1-2070 date which is hidden and I don't want to use. please see attachement.

    any ideas are appreciated.
    Waely
    Attached Images Attached Images  
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width