Any ideas on How to get last activity date of an Account's Open activity?

Thanks.

What is this LastActivityDate keep track on ?

I have a long definition script to describe the picklist value, it cannot include in helptext due to exceed the char limit.

So I thinking to have a "link/button/field" in standard object Edit page where user can click on it and it will pop up a new window. I already create the visual force page.

Any idea how can have a field/button/link in standard object Edit Page to open a new window?

Try on formula field and Hyperlink(), but formula field is read only, not show in Edit page.

Custom link & custom button not show in edit page as well.

Thank you. 

Besides Validation rule, is there any other way to validate a field?

I need to validate a field if it is empty, the field is visible for certain profile only.

E.g  hidden to Standard user profile

       visible to Marketing user profile

When a standard user login and create an account, even the field is hidden to them, validation rule is still check on the field if it is empty and return error.

Please advise. 

Thank you.

Can the audit fields (createdDate, lastModifiedDate) be updated with the dataloader or via the API?

Is there any ways to Update (data already in the system) the Created Date/ Last Modified Date in Salesforce? 

Thank you.

I have 2 date fields

- Start Date

- End Date

I want to extract data which End Date is earlier than Start Date, I try to use 'End Date < Start Date' but it return error on soql.

Would like to ask how to do date comparison in Salesforce, thank you.

Do workflows trigger when using import wizard?

I found that the workflow does not trigger when I import lead data.

Is there any settings to make the workflow trigger when using import wizard?

Thank you.

Besides Validation rule, is there any other way to validate a field?

I need to validate a field if it is empty, the field is visible for certain profile only.

E.g  hidden to Standard user profile

       visible to Marketing user profile

When a standard user login and create an account, even the field is hidden to them, validation rule is still check on the field if it is empty and return error.

Please advise. 

Thank you.

I have 2 date fields

- Start Date

- End Date

I want to extract data which End Date is earlier than Start Date, I try to use 'End Date < Start Date' but it return error on soql.

Would like to ask how to do date comparison in Salesforce, thank you.

Do workflows trigger when using import wizard?

I found that the workflow does not trigger when I import lead data.

Is there any settings to make the workflow trigger when using import wizard?

Thank you.