First, let me say I'm a CR novice. I'm trying to find out a couple of things, all date related to our customers, and can't find the right syntax for one of them. I'm looking to find the number of days between the date we enter a new customer and the date they place their first order. The date entered as a customer is a static field in the customer record. However, there's no static field in any table about the first order date. There is for the last order date, but that only works if they've placed a single order. In order to get the first order date, I need to look at all orders and select the minimum date in the order entered field. For any one customer for the time frame I'm using, there could be dozens of individual orders. Conceptually, it's quite simple, but I can't get it to work. Any ideas?

Here's the selection formula I'm using.

not ({Customer.Number}like "w*")and
{Customer.DateOpened} in Date (2018,01,01 ) to Date(2018,12,31)

I'm trying to add something to this to get the minimum date in [ticket.date_entered]. Like I said, I'm a novice at this and have no idea how to write SQL code or do a sub query. I used to be able to do a lot of things in Access, but that was almost 20 years ago.

This is a odd one...couldn't you just ask for the Minimum(orderDate, CustomerGroup)? and then do a datediff against the CustomerCreateDate?

I haven't tried it myself, it just seems like a plausible approach.

HTH