Re: filtering records between 2 dates

[Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>]

So herein lies the double-edged sword of utility functions: they do 
exactly what you tell them to do! If you run '1960101' through DATE(), 
it converts.  But it converts to '1960-04-10'.  Now THERE is a subtle 
error waiting to bite you...

On 7/18/2020 11:03 AM, Joe Pluta wrote:
> Scott, I'm the king of typos, so I like ISO because it's consistent 
> and it forces me to mentally separate the year, month and day.  Look 
> at your date again.  :)
>
> On 7/17/2020 5:06 PM, Scott Mildenberger wrote:
> > Put the format of the dates like Joe sent you '1960-01-01'.  Or I 
> > usually just use '1960101'.  Those always convert properly without 
> > relying on format settings.
> >
> > Scott Mildenberger | Software Developer | Washington Companies IT 
> > Services | 101 International Drive | Missoula, MT | Office: 
> > 406-523-1536 | www.washingtoncompanies.com