So there were several things I was doing wrong. First off earliest and latest are reserved names so you cannot use them for your own custom time variables. Secondly, I have my Date timestamp in the far Left column so $click.value$ works better than trying to shove my Column name in there which contains all kinds of spaces and special characters. Finally, to get the time stamps to be Midnight to Midnight I had to do some simple math to alter the Unix time stamp accordingly because, for whatever reason, the system was giving me essentially 11 PM to 11 PM on the date clicked whereas I want Midnight on the date click to Midnight on the next day.
<eval token="earliestTime">strptime($click.value$,"%d/%m/%y")+3600</eval>
<eval token="latestTime">strptime($click.value$,"%d/%m/%y")+90000</eval>
... View more