Find first date in recordset to use for calculated control (1 Viewer)

[lscheer]

I have an invoice report that has a calculated control for billing cycle. Currently it is set to

=[Enter start date] & "-" & [Enter end date]

This is because the start date depends on the date of the first charge and changes every month, so the user enters the dates simply for display purposes. What I was hoping to do is have the start date determined automatically based on the underlying recordset. Is there a way to find the first date in the recordset and use it as the start date in the calculated control?

 

[vbaInet]

Look into the DMax() function.

Will you still have the [Enter end date] parameter? It seems redundant to me.

 

[lscheer]

Perfect, thanks! I can't believe I spaced DMax. And yes, since DMin and DMax work for both the start and end dates, I will just use those.

 

[vbaInet]

You're welcome!