max(date) Sql Statement

Permanently deleted user

February 10, 2017 18:15

I've collected a begin date and end date from the user using a form. But I only need to find the max(date) from a list of date/times from an entire day. I only need to retrieve the max date from the query below. Any ideas from anyone?

 

 

"(Sampling_Date >= date '" + beginDate + "' AND  Sampling_Date <= date '" + endDate + "')"

 

Many thanks...Walter

0

• 

  Amanda Frech

  April 17, 2017 21:27

  Hi Walter,

   

  Is the data that you're querying in a map service (queried via QueryTask), or is it in a database table (queried via SQLQuery activity)?

   

  Thanks,

   

  Amanda

  0

Please sign in to leave a comment.