<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
OK, maybe this is because it is a migrated database, I will dig a
bit deeper, thanks Uma.<br>
<br>
Alan.<br>
<br>
<div class="moz-cite-prefix">On 28/05/15 09:16, Uma S wrote:<br>
</div>
<blockquote
cite="mid:CAH83UoKp9Rztw6KRNSa94oxvyzgMfFArEx=nPMcehkqMRQCUYw@mail.gmail.com"
type="cite">
<div dir="ltr">Sorry! We are not able reproduce this advance
filters of Reports also checked against <a
moz-do-not-send="true" href="http://demo.vtiger.com">demo.vtiger.com</a>.
<div><br>
</div>
<div>Please do check if it's possible to reproduce this issue in
demo, which will be useful to dig in dipper into the issue.</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Wed, May 27, 2015 at 6:01 PM, Alan
Bell <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:alan.bell@libertus.co.uk" target="_blank">alan.bell@libertus.co.uk</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">if you
create a report and filter on a regular date field you get
options like "last 30 days" or "Current FY" which is quite
cool, but these don't work on created and modified dates.
This is because the fieldType for these is T and not DT,
when it comes to the code in
layouts/vlayout/modules/Vtiger/resources/AdvanceFilter.js<br>
<br>
if you change the following lines:<br>
line 109<br>
if(fieldType == 'D' || fieldType ==
'DT'||fieldType=='T'){<br>
<br>
line 116<br>
if(fieldType != 'D' && fieldType != 'DT'
&& fieldType!='T') {<br>
<br>
then they are considered date type fields and work just
great (I have no idea if DT is a valid fieldtype, but when
these go through that code they are T)<br>
<br>
<br>
Alan.<br>
_______________________________________________<br>
<a moz-do-not-send="true" href="http://www.vtiger.com/"
target="_blank">http://www.vtiger.com/</a><br>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
<div class="gmail_signature">
<div dir="ltr">With<br>
Best Regards<br>
Uma.S<br>
<div>Vtiger Team</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
<a class="moz-txt-link-freetext" href="http://www.vtiger.com/">http://www.vtiger.com/</a></pre>
</blockquote>
<br>
</body>
</html>