Hi Trent,

Since when using a DateTime search field in the Browser Dialog, it wll only show the Date part instead of the DateTime, could it be possible incorporate a quick fix like this:

When using the filter expression on a DateTime search field like:

• >= SF modify the time part to be 12:00 AM
• <= SF modify the time part to be 11:59:29 PM

This will produce the correct SQL statement needed by the Dialog Browser to get the correct records.

I truly believe that the way the DB works now with date should be doing something like this under the hook.  Please consider this and let me know.

Thanks!

Edhy Rijo

Hi Trent, Ben,

Is there any news on this issue?

I really need to have a Date range functionality in the Browser Dialog for this particular form. 

The customer wants to be able to search for records and I need to provide him with an answer.

At this point I am open to any suggestion.  The fields are DateTime, but in the Browser Dialog search I just need to use the date.

Thanks!

Edhy Rijo

Hi Trent, Ben,

Well, there is not need to answer my previous request

I found the answer on this post: http://forum.strataframe.net/Topic12630-22-1.aspx and I you guys took me by surprise, I almost have a heart attach, when I saw the details for the update.

Thanks a lot for such a response.

Edhy Rijo

I would advice them to take a bit longer next time, and give you the news slower, in parts...

Seriously, now, I agree with you, it was an amazing work! As usual...

I wasn't try to give anyone Cardiac Arrest   I just knew that we have a number of people that were needing some enhancements so while I was in there, I made every change that was on my list.  Glad it got you what you needed

I had a similar problem with DateTime. Glad to see this post -- thought I was going crazy!