<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi Uma,<br>
<br>
it turns out this was a migration issue, the typeofdata was set to
T~O and had not been changed to DT~O<br>
<br>
Alan.<br>
<br>
<div class="moz-cite-prefix">On 28/05/15 12:31, Uma S wrote:<br>
</div>
<blockquote
cite="mid:CAH83UoJGuWRg-xxNT9YAmTZ5TkY=GkL_75ADxbzGixAc84ndRA@mail.gmail.com"
type="cite">
<div dir="ltr">Thanks! Alan.</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Thu, May 28, 2015 at 4:07 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">
<div 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.
<div>
<div class="h5"><br>
<br>
<div>On 28/05/15 09:16, Uma S wrote:<br>
</div>
</div>
</div>
<blockquote type="cite">
<div>
<div class="h5">
<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" target="_blank">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>
<div dir="ltr">With<br>
Best Regards<br>
Uma.S<br>
<div>Vtiger Team</div>
</div>
</div>
</div>
<br>
<fieldset></fieldset>
<br>
</div>
</div>
<pre>_______________________________________________
<a moz-do-not-send="true" href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a></pre>
</blockquote>
<br>
</div>
<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>