Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
RamuRamu 

Hi My Requirement is

Hi All,

     I have create a formula field in Quote object, formula is Product - Date - Quote no then Click on Save button it will reflect all the recored of this value.

My requirement  only it should effect on New Record only.


how can i resolve this value

Thaks in advance. 
Best Answer chosen by Ramu
Anoop yadavAnoop yadav
Do not use Semicolon:

IF(DATEVALUE(CreatedDate) > = DATE(2014,06,25), Customer_Quote_Name__c, ' ' )

All Answers

Anoop yadavAnoop yadav
Dear Ramu,

You can use DATE(year,month,day) function in formula field to achieve this.
IF(CreatedDate> = DATE(year,month,day), 'your Value', ' ' );
RamuRamu
Hi Anoop,

   i tried to acces your if code but no result, can u pls share some inputs of this issue. My forumla value is:

 Product__r.Name & " - " & Text(DAY(Customer_Quote_date__c))+"/" +Text(MONTH(Customer_Quote_date__c))+"/" +Text(YEAR(Customer_Quote_date__c)) & " - " & Name
Anoop yadavAnoop yadav
Hi Ramu,

You can create two formula field.
Use First formula Like this:
Formula1 = Product__r.Name & " - " & Text(DAY(Customer_Quote_date__c))+"/" +Text(MONTH(Customer_Quote_date__c))+"/" +Text(YEAR(Customer_Quote_date__c)) & " - " & Name

And Second formula Like this:
formula2 = IF(CreatedDate> = DATE(2014,06,25), Formula1, ' ' );

Try this..
RamuRamu
Hi Anoop,

     it's not working, pls give me any idea about this.
Anoop yadavAnoop yadav
Let me know what are you doing currently.
and what result are you getting in formulas.
RamuRamu
Hi Anoop,

   create formula-2  field and execute

IF(CreatedDate> = DATE(2014,06,25), Product__r.Name & " - " & Text(DAY(Customer_Quote_date__c))+"/" +Text(MONTH(Customer_Quote_date__c))+"/" +Text(YEAR(Customer_Quote_date__c)) & " - " & Name, ' ' );

getting Error: Syntax error. Found '=' 

Second Error: Incorrect parameter type for operator '>='. Expected DateTime, received Date
 
Anoop yadavAnoop yadav
Replace this part :   Product__r.Name & " - " & Text(DAY(Customer_Quote_date__c))+"/" +Text(MONTH(Customer_Quote_date__c))+"/" +Text(YEAR(Customer_Quote_date__c)) & " - " & Name

with your formula Field Name Like: Formula__c

it will work
Anoop yadavAnoop yadav
Try this:

IF(DATE(CreatedDate) > = DATE(2014,06,25), Product__r.Name & " - " & Text(DAY(Customer_Quote_date__c))+"/" +Text(MONTH(Customer_Quote_date__c))+"/" +Text(YEAR(Customer_Quote_date__c)) & " - " & Name, ' ' );
RamuRamu
getting same error: 

 Error: Incorrect parameter type for operator '>='. Expected DateTime, received Date 
RamuRamu
 Hi,

  IF(DATE(CreatedDate) > = DATE(2014,06,25), Product__r.Name & " - " & Text(DAY(Customer_Quote_date__c))+"/" +Text(MONTH(Customer_Quote_date__c))+"/" +Text(YEAR(Customer_Quote_date__c)) & " - " & Name, ' ' );

use above formula getting this error Error: Incorrect number of parameters for function 'DATE()'. Expected 3, received 1
Anoop yadavAnoop yadav
What are yours first and second formula Field Name and return Type?
RamuRamu
First Formula Field name:  Customer_Quote_Name__c

Second Formula Field name : Customer_Quote_Name1__c
 
using Formula -->  Text field
Anoop yadavAnoop yadav
Try this:

IF(DATE(CreatedDate) > = DATE(2014,06,25), Customer_Quote_Name__c, ' ' );

This formula will display values for todays created records.
If records are created before today, it will not display any values in this.
RamuRamu
Hi Anoop,

   This formula executed on Second Formula field right, 

if right getting same error else pls tell me where this formula executed
Anoop yadavAnoop yadav
Sorry I should use DATEVALUE in place of DATE.
Use this in second formula:

IF(DATEVALUE(CreatedDate) > = DATE(2014,06,25), Customer_Quote_Name__c, ' ' );

Now it will work.
Anoop yadavAnoop yadav
Do not use Semicolon:

IF(DATEVALUE(CreatedDate) > = DATE(2014,06,25), Customer_Quote_Name__c, ' ' )

This was selected as the best answer
RamuRamu
Hi Anoop,

   it's working.

Thanks for your Help.