[Vtigercrm-developers] Access to "Create time" & "Modify time"

[Stephen Mack]

Just to close the loop, here is everything

1) Call the built-in function in data\CRMEntity.php

retrieve_entity_info($_REQUEST['record'],"Quotes")

2) The information is now stored in the variable $column_fields

$focus->column_fields["modifiedtime"]

3) Format the output.  You need to convert the string to an integer
and format it as you like.

date("d M Y", strtotime($focus->column_fields["modifiedtime"]))

If I'm wrong someone can correct me please.

-- Stephen Mack
Gerente de Ventas y Marketing
Escuela Fronteras
www.eFronteras.com
skype: eFronteras.Stephen



On Wed, Apr 29, 2009 at 11:52 AM, Stephen Mack <stephen at efronteras.com> wrote:
> Hi everyone and Sebastian,
>
> Ok I also found out that the function...
> retrieve_entity_info($_REQUEST['record'],"Quotes");
>
> ...also retrieves the information.  It's accessible in the
> column_fields variable.
>
> $modified_date = $focus->column_fields["modifiedtime"];
>
> -- Stephen Mack
> Gerente de Ventas y Marketing
> Escuela Fronteras
> www.eFronteras.com
> skype: eFronteras.Stephen
>
>
>
> On Wed, Apr 29, 2009 at 11:33 AM, Stephen Mack <stephen at efronteras.com> wrote:
>> Hummm... can someone confirm that this is the information is correct.
>> I think it is...
>>
>> SELECT *
>> FROM  `vtiger_quotes`
>> LEFT JOIN  `vtiger_crmentity` ON  `quoteid` =  `crmid`
>> WHERE 1
>>
>> -- Stephen Mack
>> Gerente de Ventas y Marketing
>> Escuela Fronteras
>> www.eFronteras.com
>> skype: eFronteras.Stephen
>>
>>
>>
>> On Wed, Apr 29, 2009 at 11:15 AM, Stephen Mack <stephen at efronteras.com> wrote:
>>> It seems like I should have figured this out already... :(
>>>
>>> I would like to use the "Modify Time" from a quote on the PDF.  I
>>> can't find where the "Create time" & "Modify time" are stored for a
>>> quote.
>>>
>>> -- Stephen Mack
>>> Gerente de Ventas y Marketing
>>> Escuela Fronteras
>>> www.eFronteras.com
>>> skype: eFronteras.Stephen
>>>
>>
>