Hi Stephen,<br><br>Things look fine the way you are trying to consume modified time. Let me also clarify that, the created time and modified time are stored in vtiger_crmentity table.<br><br><div><span class="gmail_quote">On 4/29/09, <b class="gmail_sendername">Stephen Mack</b> <<a href="mailto:stephen@efronteras.com">stephen@efronteras.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Just to close the loop, here is everything<br> <br> 1) Call the built-in function in data\CRMEntity.php<br> <br><br> retrieve_entity_info($_REQUEST['record'],"Quotes")<br> <br> <br>2) The information is now stored in the variable $column_fields<br>
<br> $focus->column_fields["modifiedtime"]<br> <br> 3) Format the output. You need to convert the string to an integer<br> and format it as you like.<br> <br> date("d M Y", strtotime($focus->column_fields["modifiedtime"]))<br>
<br> If I'm wrong someone can correct me please.<br> <br><br> -- Stephen Mack<br> Gerente de Ventas y Marketing<br> Escuela Fronteras<br> <a href="http://www.eFronteras.com">www.eFronteras.com</a><br> skype: eFronteras.Stephen<br>
<br> <br> <br> <br>On Wed, Apr 29, 2009 at 11:52 AM, Stephen Mack <<a href="mailto:stephen@efronteras.com">stephen@efronteras.com</a>> wrote:<br> > Hi everyone and Sebastian,<br> ><br> > Ok I also found out that the function...<br>
> retrieve_entity_info($_REQUEST['record'],"Quotes");<br> ><br> > ...also retrieves the information. It's accessible in the<br> > column_fields variable.<br> ><br> > $modified_date = $focus->column_fields["modifiedtime"];<br>
><br> > -- Stephen Mack<br> > Gerente de Ventas y Marketing<br> > Escuela Fronteras<br> > <a href="http://www.eFronteras.com">www.eFronteras.com</a><br> > skype: eFronteras.Stephen<br> ><br> ><br>
><br> > On Wed, Apr 29, 2009 at 11:33 AM, Stephen Mack <<a href="mailto:stephen@efronteras.com">stephen@efronteras.com</a>> wrote:<br> >> Hummm... can someone confirm that this is the information is correct.<br>
>> I think it is...<br> >><br> >> SELECT *<br> >> FROM `vtiger_quotes`<br> >> LEFT JOIN `vtiger_crmentity` ON `quoteid` = `crmid`<br> >> WHERE 1<br> >><br> >> -- Stephen Mack<br>
>> Gerente de Ventas y Marketing<br> >> Escuela Fronteras<br> >> <a href="http://www.eFronteras.com">www.eFronteras.com</a><br> >> skype: eFronteras.Stephen<br> >><br> >><br> >><br>
>> On Wed, Apr 29, 2009 at 11:15 AM, Stephen Mack <<a href="mailto:stephen@efronteras.com">stephen@efronteras.com</a>> wrote:<br> >>> It seems like I should have figured this out already... :(<br> >>><br>
>>> I would like to use the "Modify Time" from a quote on the PDF. I<br> >>> can't find where the "Create time" & "Modify time" are stored for a<br> >>> quote.<br>
>>><br> >>> -- Stephen Mack<br> >>> Gerente de Ventas y Marketing<br> >>> Escuela Fronteras<br> >>> <a href="http://www.eFronteras.com">www.eFronteras.com</a><br> >>> skype: eFronteras.Stephen<br>
>>><br> >><br> ><br> <br> _______________________________________________<br> Reach hundreds of potential candidates - <a href="http://jobs.vtiger.com">http://jobs.vtiger.com</a><br> </blockquote></div>
<br><br clear="all"><br>-- <br>Regards,<br>Asha<br>vtiger Team