Aug 8, 2005 #1 DBAFrog Programmer Sep 26, 2002 61 US We have benefits that get updated each year. I need to pull the MAX(START_DATE), but... this syntax works fine in SQL, but Crystal doesn't like it. What is the correct syntax? thanks ------------------ Curious by Nature, Linux by Design
We have benefits that get updated each year. I need to pull the MAX(START_DATE), but... this syntax works fine in SQL, but Crystal doesn't like it. What is the correct syntax? thanks ------------------ Curious by Nature, Linux by Design
Aug 8, 2005 #2 TheBlondOne Programmer May 22, 2001 346 GB Try maximum({Start date}) HTH Upvote 0 Downvote
Aug 8, 2005 Thread starter #3 DBAFrog Programmer Sep 26, 2002 61 US ty ------------------ Curious by Nature, Linux by Design Upvote 0 Downvote