I am trying to set the hour in a time date field but am unsure how to add the hours to the field - every time i try and add the 'start time' field salesforce is just adding days to the formula.

this is the formula as i have it at the moment : DATETIMEVALUE(CloseDate +(TimeOfAppointment__c) )

So what i am hoping for is that if the field with the time of the appointment, say 10, the formula would would show 10am on the closedate.

the reason behind this is that i am trying to create an event in visual workflow and i am unable to create a timedate field so was going to use this to create the start and end times for an event

Hello everybody,

I could write validation rule to prevent half entry of address...But it is not accepting when it is completely blank.

The validation rule I have written is 

OR(
OR(
Billing_Street__c<>null,
ISBLANK( Billing_City__c ),
ISBLANK( Billing_State__c ),
ISBLANK( Billing_Country__c ),
ISBLANK(Billing_Zip_Code__c )),

OR(
Billing_City__c<>null,
ISBLANK( Billing_Street__c ),
ISBLANK( Billing_State__c ),
ISBLANK( Billing_Country__c ),
ISBLANK(Billing_Zip_Code__c )),

OR(
Billing_State__c<>null,
ISBLANK( Billing_City__c ),
ISBLANK( Billing_Street__c ),
ISBLANK( Billing_Country__c ),
ISBLANK(Billing_Zip_Code__c )),

OR(
Billing_Country__c<>null,
ISBLANK( Billing_City__c ),
ISBLANK( Billing_State__c ),
ISBLANK( Billing_Street__c ),
ISBLANK(Billing_Zip_Code__c )),

OR(
Billing_Zip_Code__c<>null,
ISBLANK( Billing_City__c ),
ISBLANK( Billing_State__c ),
ISBLANK( Billing_Country__c ),
ISBLANK(Billing_Street__c )))

Can you please tell me what is the mistake?? By the way I am new to sfdc.

Thanks.

Hi, first time poster long time reader

In essence I am creaiting a new tab related to time based information

Having created all fields required, I have imported historic data.

Where I have times of 23:07 or 22:43

I am seeing only 23.0 or at best 22:4

Having read all the other forum help topics is there a simple way of formating my field to enable me to show 23:07 without displaying a date

If someone could be kind enough to post me a fools guide on how to do this I would be most grateful

Summary:

Simply want to be able to import times without creating or adding a date to the records 

I am trying to set the hour in a time date field but am unsure how to add the hours to the field - every time i try and add the 'start time' field salesforce is just adding days to the formula.

this is the formula as i have it at the moment : DATETIMEVALUE(CloseDate +(TimeOfAppointment__c) )

So what i am hoping for is that if the field with the time of the appointment, say 10, the formula would would show 10am on the closedate.

the reason behind this is that i am trying to create an event in visual workflow and i am unable to create a timedate field so was going to use this to create the start and end times for an event

I have a VR written to require the user to enter the Contract Term # of Months, once the opportunity in a particular record type reaches a certain stage (stage 6) or higher.

However, its not working - any ideas?

Here is the formula as it stands now:

AND (
OR (
ISPICKVAL(StageName, "6 - Proposal/MOU Presented"),
ISPICKVAL(StageName, "7 - Verbal Acceptance"),
ISPICKVAL(StageName, "8 - Contract Sent/Negotiations"),
ISPICKVAL(StageName, "9 - Contract Executed"),
ISPICKVAL(StageName, "10 - Contract Validated "),
ISPICKVAL(StageName, "11 - Internal Kickoff Completed"),
ISPICKVAL(StageName, "12 - Customer Kickoff Completed"),
ISPICKVAL(StageName, "13 - Integration Instructions Sent"),
ISPICKVAL(StageName, "14 - Certification Complete"),
ISPICKVAL(StageName, "15 - Approved for Production"),
ISPICKVAL(StageName, "16 - Launched to Production")),
RecordType.Id="01280000000Luw9AAC",
ISBLANK(Contract_Term_Months__c)
)

I'm trying to get a field to auto update based on a date field.

If the Close date = 6/14/2013 

then new custom field  = 7/1/2013

Basically if any date falls in the month of june, i.e. 6/2/2013, 6/28/2013, 6/16/2013, the new custom field updates to 7/1/2013.

Would that be a workflow rule with a field update or can it be a field formula? Any help is appreciated. Thanks!

Hello,

I am new to SalesForce. We are trying it out to see if it is what we are looking for.  We have already created sku's on our website to pass through to SalesForce when a payment is complete.  I have set up an auto email to send to customers with their billing address, ammount etc.  What is throwing me for a loop is this. We have multiple sku's on our site as we sell hundreds of products.  What I am trying to do is add a description with the sku. So when customer "A" orders 1 Raspberry Ketone from our site right now it passes as 1:RBKVTL. I have this added to the email already. What I want to add is somethign like "If the sku shipped contains RBKVTL description is "Raspberry Ketone". But I need to do this for all of my products.  This is what I have so far:

IF(CONTAINS(Sku_Shipped_1__c, "green"), "Green Coffee", "Green Coffee") 
& 
IF(CONTAINS(Sku_Shipped_1__c, "RBKVTL"), "Raspberry Ketone", "Raspberry Ketone")

This is obviously wrong as every email passes through "Green Coffee Rapsberry Ketone" no matter what they order.

Thanks in advance for the help, please be gentle with me :)

Sadie

Hi,

I have a formula that makes a field required if certain requirements are met.  I found out that it is effecting older cases where this new field wasn't active yet.

How do I put a qualifier on the formula so that it only applies to cases created after 6/30/2103?

My formula is

AND(ISPICKVAL( Product_Category__c , "Defense Technology"), TEXT(Order_Contains_ATF_Items__c)="") && $RecordType.Name = "Customer Care" &&  ISPICKVAL(Case_Type__c , "Place an Order") && ISPICKVAL(Status, "Closed")&& CreateDate < 2013-06-30T00:00:00.000Z

My error message states Error: Syntax error. Extra T00:00:00.000Z

Thanks. :)

Hello everybody,

I could write validation rule to prevent half entry of address...But it is not accepting when it is completely blank.

The validation rule I have written is 

OR(
OR(
Billing_Street__c<>null,
ISBLANK( Billing_City__c ),
ISBLANK( Billing_State__c ),
ISBLANK( Billing_Country__c ),
ISBLANK(Billing_Zip_Code__c )),

OR(
Billing_City__c<>null,
ISBLANK( Billing_Street__c ),
ISBLANK( Billing_State__c ),
ISBLANK( Billing_Country__c ),
ISBLANK(Billing_Zip_Code__c )),

OR(
Billing_State__c<>null,
ISBLANK( Billing_City__c ),
ISBLANK( Billing_Street__c ),
ISBLANK( Billing_Country__c ),
ISBLANK(Billing_Zip_Code__c )),

OR(
Billing_Country__c<>null,
ISBLANK( Billing_City__c ),
ISBLANK( Billing_State__c ),
ISBLANK( Billing_Street__c ),
ISBLANK(Billing_Zip_Code__c )),

OR(
Billing_Zip_Code__c<>null,
ISBLANK( Billing_City__c ),
ISBLANK( Billing_State__c ),
ISBLANK( Billing_Country__c ),
ISBLANK(Billing_Street__c )))

Can you please tell me what is the mistake?? By the way I am new to sfdc.

Thanks.