• Tracy Oden 31
  • NEWBIE
  • 20 Points
  • Member since 2016

  • Chatter
    Feed
  • 0
    Best Answers
  • 1
    Likes Received
  • 0
    Likes Given
  • 8
    Questions
  • 13
    Replies
I have an old dev org. The dev org doesn't have the new sales console. Salesforce provided me with a consolude user license but it give access to a old console (even with lightning enabled), not the new sales console as a more recent org. Any idea how to get the new sales console lightnitng in my older org?
Hi, I am trying to write a datetime formula but having a problem. The goal is to check a 'date' field (Service_Date__c) to determine if the (Service_Date__c) date field is blank. If the (Service_Date__c) date field is blank, I want to return null. If the date field is not blank, then I want to return the following 'datetime' formula DateTime__c +   300/1440.

I have some other formulas dependendent on the 'datetime' formula DateTime__c. The DateTime__c field is a formula field that is depenendent on the Service_Date__c 'date' field--all of which are throwing errors. I can fix the errors if I can get help with the above.

Thank you in advance!

IF(NOT(ISBLANK(Service_Date__c)), DateTime__c   +   300/1440)
Is it possible to use process builder to cloase an open task? If so, can someone provide guidance?
Is it possible to use Flow to create a Chatter group? If so; can someone explain how?
I need help with a Flow error.

I have a rather large flow. When I try to save, the session times out and I get an error saying the flow version no longer exist to' save as a new version'. This works, but there is flow govenor limit of 50. I am now on 34. 

Q1: Does anyone know what is causing this probem and how to resolve it?
Q2: I have deleted many of my previous flow versions to avoid the govenor limit. I am on version 34 but only have 2 saved versions (after deleting the others). Does govenor limits impact the total number of flow versions or just those that are present (those that have not been deleted)?

Your response is greatly appreciated.
This should be simple, but I can't figure it out. How do I add a second to a date and time field in a formula? I have a 'end' date and time field. I want my formula field to show 'next' available date and time. The next available should be one second from end date and time.
Hopefully someone can help. I am new to VF.  I desperately need someone to write a code example for me.

I am creating a resume page that renders as a PDF. I am running itnot a few problems,

I have two custom objects for which the VF page will need to display data.
  • Object A contains the name of a single practitioner (with some additional personal details).
  • Object B contains all the technical details of a single practitioner on a single engagement.
  • A lookkup field is on Object B relating it to Object A.
  • There are many Object Bs but only one Object A.
I want to use the stanard controller on the VF page for custom Object A.

1) I need to know how to reference fields from Object B into the page. An example would be great.
2) Since there are many Object B records containing skills for a praticiular practitioner;  I also need to know how to refenerence each skill from each Object B into the single VF page. (an example would be great)!

Thanks in advance for anyone who can help!
I am trying to render this page as a pdf. Although the page works fine, when I render as PDF I get a PDF Generation Failed error telling me to check the markup language.  Can someone please help.

See code:
<apex:page standardController="Statement_of_Work__c" sidebar="false" renderAs="pdf">
    <apex:pageBlock title="Statement of Work" ><p></p>
        <center><b>Statement of Work</b></center><p></p>
        <apex:pageBlockSection title="STATEMENT OF WORK DETAILS" collapsible="false">
        </apex:pageBlockSection>
          
                <table align="center" style="width:80%">
                  <tr>
                    <th>SOW Number:</th> 
                    <td>{!Statement_of_Work__c.Name}</td> 
                    <th>Revision Number:</th>
                    <td>{!Statement_of_Work__c.Revision_Version__c}</td>
                  </tr>
                  <tr>
                    <th>MSA Number:</th>
                    <td>{!Statement_of_Work__c.Master_Services_Agreement__r.name}</td>
                    <th>SOW Name:</th>
                    <td>{!Statement_of_Work__c.Statement_of_Work_Name__c}</td>
                  </tr>
                  <tr>
                    <th>Project Number:</th>
                    <td>{!Statement_of_Work__c.Project__r.name}</td>
                    <th>Account Name:</th>
                    <td>{!Statement_of_Work__c.Account_Name__c}</td>
                  </tr>
                  <tr>
                    <th>Start Date:</th>
                    <td>{!Statement_of_Work__c.Start_Date__c}</td>
                    <th>End Date:</th>
                    <td>{!Statement_of_Work__c.End_Date__c}</td>
                  </tr>
                  <tr>
                    <th>Project Billing Address:</th>
                    <td>{!Statement_of_Work__c.Billing_Street__c}</td>
                    <th>Project Address:</th>
                    <td>{!Statement_of_Work__c.Project_Street__c}</td>
                  </tr>
                  <tr>
                    <th>Project Billing City:</th>
                    <td>{!Statement_of_Work__c.Billing_City__c}</td>
                    <th>Project CIty:</th>
                    <td>{!Statement_of_Work__c.Project_City__c}</td>
                  </tr>
                  <tr>
                    <th>Project Billing State/Province:</th>
                    <td>{!Statement_of_Work__c.Billing_State_Province__c}</td>
                    <th>Project State/Province:</th>
                    <td>{!Statement_of_Work__c.Project_State_Province__c}</td>
                  </tr>
                  <tr>
                    <th>Project Billing Zip/Postal Code:</th>
                    <td>{!Statement_of_Work__c.Billing_Zip_Postal_Code__c}</td>
                    <th>Project Zip/Postal Code:</th>
                    <td>{!Statement_of_Work__c.Project_Zip_Postal_Code__c}</td>
                  </tr>
                  <tr>
                    <th>Project Billing Country:</th>
                    <td>{!Statement_of_Work__c.Billing_Country__c}</td>
                    <th>Project Country:</th>
                    <td>{!Statement_of_Work__c.Project_Country__c}</td>
                  </tr>
                </table>
                
        <apex:pageBlockSection title="SCOPE" collapsible="false" columns="1"><p></p>
                  <b>PROJECT BACKGROUND</b><p></p>
                  <p></p> {!Statement_of_Work__c.Project_Background__c}<p></p>
                  <b>PERIOD OF PERFORMANCE</b><p></p>
                  <p></p> {!Statement_of_Work__c.Period_of_Performance__c}<p></p>
                  <b>PLACE OF PERFORMANCE</b><p></p>
                  <p></p> {!Statement_of_Work__c.Place_of_Performance__c}<p></p>
                  <b>SCOPE OF WORK</b><p></p>
                  <p></p>{!Statement_of_Work__c.Scope_of_Work__c}<p></p>
                  <b>DELIVERABLES DUE</b><p></p>
                  <p></p>{!Statement_of_Work__c.Deliverables__c}<p></p>
         </apex:pageBlockSection>
         
         <apex:pageBlockSection title="ENGAGEMENT DETAILS" columns="1" collapsible="false">
                  <table align="left" style="width:95%">
                  <tr>
                    <th>Price:</th> 
                    <td>{!Statement_of_Work__c.Price__c}</td> 
                    <th>Engagement Type:</th>
                    <td>{!Statement_of_Work__c.Pricing_Type__c}</td>
                  </tr>
                  <tr>
                    <th>Delivery Preference:</th>
                    <td>{!Statement_of_Work__c.Delivery_Preference__c}</td>
                    <th>Duration in Hours:</th>
                    <td>{!Statement_of_Work__c.Engagement_Duration_hours__c}</td>
                  </tr>
                  <tr>
                    <th>Duration in Weeks:</th>
                    <td>{!Statement_of_Work__c.Engagement_Duration_weeks__c}</td>
                    <th>Duration in Months:</th>
                    <td>{!Statement_of_Work__c.Engagement_Duration_months__c}</td>
                  </tr>
                  </table><p></p>
          </apex:pageBlockSection>
          
          <apex:pageBlockSection title="EXPENSES" columns="1" collapsible="false">
                  <p></p><b>EXPENSES</b> <p></p> {!Statement_of_Work__c.Expense_Itemization__c}
          </apex:pageBlockSection>
          
                  <p></p>
          <apex:pageBlockSection title="ONBORADING & CLOSING REQUIREMENTS" columns="1" collapsible="false">
                   <p></p><b>ONBOARDING REQUIREMENTS</b> <p></p> {!Statement_of_Work__c.Onboarding_Tasks__c}
                   <p></p><b>CLOSING REQUIREMENTS</b> <p></p> {!Statement_of_Work__c.Closing_Tasks__c}
          </apex:pageBlockSection>
          
          <apex:pageBlockSection title="WORK REQUIREMENTS" columns="1" collapsible="false">
                     <table align="left" style="width:95%">
                     <tr>
                     <th>Plan Phase:</th> 
                     <td>{!Statement_of_Work__c.Plan_Phase__c}</td> 
                     <th>Design Phase:</th>
                     <td>{!Statement_of_Work__c.Design_Phase__c}</td>
                     </tr>
                     <tr>
                     <th>Develop Phase:</th>
                     <td>{!Statement_of_Work__c.Develop_Phase__c}</td>
                     <th>Test Phase:</th>
                     <td>{!Statement_of_Work__c.Test_Phase__c}</td>
                     </tr>
                     <tr>
                     <th>Train Phase:</th>
                     <td>{!Statement_of_Work__c.Train_Phase__c}</td>
                     <th>Cutover Phase:</th>
                     <td>{!Statement_of_Work__c.Cutover_Phase__c}</td>
                     </tr>
                     <tr>
                     <th>Production:</th>
                     <td>{!Statement_of_Work__c.Production_Phase__c}</td>
                     <th>Post Production Phase:</th>
                     <td>{!Statement_of_Work__c.Post_Production_Phase__c}</td>
                     </tr>
                     </table>
          </apex:pageBlockSection>
                             
             <apex:pageBlockSection title="SCHEDULE" columns="1" collapsible="false">
                        <b>SCHEDULE</b><p></p>
                        <p></p> {!Statement_of_Work__c.Schedule__c}<p></p>
             </apex:pageBlockSection>
             
             <apex:pageBlockSection title="ADDITIONAL REQUIREMENTS" columns="1" collapsible="false">
                        <b>ACCEPTANCE CRITERIA</b><p></p>
                        <p></p> {!Statement_of_Work__c.Acceptance_Criteria__c}<p></p>
                        <b>ADDITIONAL CRITERIA</b><p></p>
                        <p></p> {!Statement_of_Work__c.Additional_Requirements__c}<p></p>    
             </apex:pageBlockSection>
             
             <apex:pageBlockSection title="ADDITIONAL SCOPE CRITERIA" columns="1" collapsible="false">
                        <b>SUCCESS CRITERIA</b><p></p>
                        <p></p> {!Statement_of_Work__c.Scope_Success_Criteria__c}<p></p>
                        <b>ASSUMPTIONS</b><p></p>
                        <p></p> {!Statement_of_Work__c.Scope_Assumptions__c}<p></p>
                        <b>DEPENDENCIES</b><p></p>
                        <p></p> {!Statement_of_Work__c.Scope_Dependencies__c}<p></p>
                        <b>CONSTRAINTS</b><p></p>
                        <p></p> {!Statement_of_Work__c.Scope_Constraints__c}<p></p>
                        <b>RISKS</b><p></p>
                        <p></p> {!Statement_of_Work__c.Scope_Risks__c}<p></p>
                        <b>CHANGE CONTROL</b><p></p>
                        <p></p> {!Statement_of_Work__c.Scope_Change_Control__c}<p></p>
                        <b>PROJECT COMMUNICATION</b><p></p>
                        <p></p> {!Statement_of_Work__c.Scope_Project_Communication__c}<p></p>
              <apex:pageBlockSection title="SIGNATURES" columns="1" collapsible="false">
                        <table align="left" style="width:95%">
                         <tr>
                         <th>Client (Owner) Name:</th> 
                         <td>{!Statement_of_Work__c.Client_Signed_By__r.name}</td> 
                         <th>Consulting Firm (Consultant) Name:</th>
                         <td>{!Statement_of_Work__c.Customer_Signed_By__r.name}</td>
                         </tr>
                         <tr>
                         <th>Title:</th>
                         <td>{!Statement_of_Work__c.Client_Signed_By__r.title}</td>
                         <th>Title:</th>
                         <td>{!Statement_of_Work__c.Company_Signed_By_Title__c}</td>
                         </tr>
                         <tr>
                         <th>Date:</th>
                         <td>{!Statement_of_Work__c.Client_Signed_Date__c}</td>
                         <th>Date:</th>
                         <td>{!Statement_of_Work__c.Customer_Signed_Date__c}</td>
                         </tr>
                         <tr>
                         <th></th>
                         <td></td>
                         <th></th>
                         <td></td>
                         </tr>
                         <tr>
                         <th>Signature:</th>
                         <td>________________________________________</td>
                         <th>Signature:</th>
                         <td>________________________________________</td>
                         </tr>
                         </table>
    
              </apex:pageBlockSection>
              </apex:pageBlockSection>
                      
            <apex:pageBlockSection collapsible="false">
        </apex:pageBlockSection>   
                   
    </apex:pageBlock>
</apex:page>


 
Hi, I am trying to write a datetime formula but having a problem. The goal is to check a 'date' field (Service_Date__c) to determine if the (Service_Date__c) date field is blank. If the (Service_Date__c) date field is blank, I want to return null. If the date field is not blank, then I want to return the following 'datetime' formula DateTime__c +   300/1440.

I have some other formulas dependendent on the 'datetime' formula DateTime__c. The DateTime__c field is a formula field that is depenendent on the Service_Date__c 'date' field--all of which are throwing errors. I can fix the errors if I can get help with the above.

Thank you in advance!

IF(NOT(ISBLANK(Service_Date__c)), DateTime__c   +   300/1440)
I go to create a new Force.com project. I get here and the next button won't work.
force.com project logon window

Known:
  • I know the data entered is correct. (The abouve has dummy data in it for security reasons).
  • It isn't a proxy or firewall issue.
  • I've tried redownloading Eclipse again and installing to a different directory. Made no difference. 
  • Java is up to date. 
  • Tried a different PC in the office - works fine on that unit. 
Hi, I am trying to write a datetime formula but having a problem. The goal is to check a 'date' field (Service_Date__c) to determine if the (Service_Date__c) date field is blank. If the (Service_Date__c) date field is blank, I want to return null. If the date field is not blank, then I want to return the following 'datetime' formula DateTime__c +   300/1440.

I have some other formulas dependendent on the 'datetime' formula DateTime__c. The DateTime__c field is a formula field that is depenendent on the Service_Date__c 'date' field--all of which are throwing errors. I can fix the errors if I can get help with the above.

Thank you in advance!

IF(NOT(ISBLANK(Service_Date__c)), DateTime__c   +   300/1440)
Is it possible to use process builder to cloase an open task? If so, can someone provide guidance?
I need help with a Flow error.

I have a rather large flow. When I try to save, the session times out and I get an error saying the flow version no longer exist to' save as a new version'. This works, but there is flow govenor limit of 50. I am now on 34. 

Q1: Does anyone know what is causing this probem and how to resolve it?
Q2: I have deleted many of my previous flow versions to avoid the govenor limit. I am on version 34 but only have 2 saved versions (after deleting the others). Does govenor limits impact the total number of flow versions or just those that are present (those that have not been deleted)?

Your response is greatly appreciated.
This should be simple, but I can't figure it out. How do I add a second to a date and time field in a formula? I have a 'end' date and time field. I want my formula field to show 'next' available date and time. The next available should be one second from end date and time.
Hopefully someone can help. I am new to VF.  I desperately need someone to write a code example for me.

I am creating a resume page that renders as a PDF. I am running itnot a few problems,

I have two custom objects for which the VF page will need to display data.
  • Object A contains the name of a single practitioner (with some additional personal details).
  • Object B contains all the technical details of a single practitioner on a single engagement.
  • A lookkup field is on Object B relating it to Object A.
  • There are many Object Bs but only one Object A.
I want to use the stanard controller on the VF page for custom Object A.

1) I need to know how to reference fields from Object B into the page. An example would be great.
2) Since there are many Object B records containing skills for a praticiular practitioner;  I also need to know how to refenerence each skill from each Object B into the single VF page. (an example would be great)!

Thanks in advance for anyone who can help!
I am trying to render this page as a pdf. Although the page works fine, when I render as PDF I get a PDF Generation Failed error telling me to check the markup language.  Can someone please help.

See code:
<apex:page standardController="Statement_of_Work__c" sidebar="false" renderAs="pdf">
    <apex:pageBlock title="Statement of Work" ><p></p>
        <center><b>Statement of Work</b></center><p></p>
        <apex:pageBlockSection title="STATEMENT OF WORK DETAILS" collapsible="false">
        </apex:pageBlockSection>
          
                <table align="center" style="width:80%">
                  <tr>
                    <th>SOW Number:</th> 
                    <td>{!Statement_of_Work__c.Name}</td> 
                    <th>Revision Number:</th>
                    <td>{!Statement_of_Work__c.Revision_Version__c}</td>
                  </tr>
                  <tr>
                    <th>MSA Number:</th>
                    <td>{!Statement_of_Work__c.Master_Services_Agreement__r.name}</td>
                    <th>SOW Name:</th>
                    <td>{!Statement_of_Work__c.Statement_of_Work_Name__c}</td>
                  </tr>
                  <tr>
                    <th>Project Number:</th>
                    <td>{!Statement_of_Work__c.Project__r.name}</td>
                    <th>Account Name:</th>
                    <td>{!Statement_of_Work__c.Account_Name__c}</td>
                  </tr>
                  <tr>
                    <th>Start Date:</th>
                    <td>{!Statement_of_Work__c.Start_Date__c}</td>
                    <th>End Date:</th>
                    <td>{!Statement_of_Work__c.End_Date__c}</td>
                  </tr>
                  <tr>
                    <th>Project Billing Address:</th>
                    <td>{!Statement_of_Work__c.Billing_Street__c}</td>
                    <th>Project Address:</th>
                    <td>{!Statement_of_Work__c.Project_Street__c}</td>
                  </tr>
                  <tr>
                    <th>Project Billing City:</th>
                    <td>{!Statement_of_Work__c.Billing_City__c}</td>
                    <th>Project CIty:</th>
                    <td>{!Statement_of_Work__c.Project_City__c}</td>
                  </tr>
                  <tr>
                    <th>Project Billing State/Province:</th>
                    <td>{!Statement_of_Work__c.Billing_State_Province__c}</td>
                    <th>Project State/Province:</th>
                    <td>{!Statement_of_Work__c.Project_State_Province__c}</td>
                  </tr>
                  <tr>
                    <th>Project Billing Zip/Postal Code:</th>
                    <td>{!Statement_of_Work__c.Billing_Zip_Postal_Code__c}</td>
                    <th>Project Zip/Postal Code:</th>
                    <td>{!Statement_of_Work__c.Project_Zip_Postal_Code__c}</td>
                  </tr>
                  <tr>
                    <th>Project Billing Country:</th>
                    <td>{!Statement_of_Work__c.Billing_Country__c}</td>
                    <th>Project Country:</th>
                    <td>{!Statement_of_Work__c.Project_Country__c}</td>
                  </tr>
                </table>
                
        <apex:pageBlockSection title="SCOPE" collapsible="false" columns="1"><p></p>
                  <b>PROJECT BACKGROUND</b><p></p>
                  <p></p> {!Statement_of_Work__c.Project_Background__c}<p></p>
                  <b>PERIOD OF PERFORMANCE</b><p></p>
                  <p></p> {!Statement_of_Work__c.Period_of_Performance__c}<p></p>
                  <b>PLACE OF PERFORMANCE</b><p></p>
                  <p></p> {!Statement_of_Work__c.Place_of_Performance__c}<p></p>
                  <b>SCOPE OF WORK</b><p></p>
                  <p></p>{!Statement_of_Work__c.Scope_of_Work__c}<p></p>
                  <b>DELIVERABLES DUE</b><p></p>
                  <p></p>{!Statement_of_Work__c.Deliverables__c}<p></p>
         </apex:pageBlockSection>
         
         <apex:pageBlockSection title="ENGAGEMENT DETAILS" columns="1" collapsible="false">
                  <table align="left" style="width:95%">
                  <tr>
                    <th>Price:</th> 
                    <td>{!Statement_of_Work__c.Price__c}</td> 
                    <th>Engagement Type:</th>
                    <td>{!Statement_of_Work__c.Pricing_Type__c}</td>
                  </tr>
                  <tr>
                    <th>Delivery Preference:</th>
                    <td>{!Statement_of_Work__c.Delivery_Preference__c}</td>
                    <th>Duration in Hours:</th>
                    <td>{!Statement_of_Work__c.Engagement_Duration_hours__c}</td>
                  </tr>
                  <tr>
                    <th>Duration in Weeks:</th>
                    <td>{!Statement_of_Work__c.Engagement_Duration_weeks__c}</td>
                    <th>Duration in Months:</th>
                    <td>{!Statement_of_Work__c.Engagement_Duration_months__c}</td>
                  </tr>
                  </table><p></p>
          </apex:pageBlockSection>
          
          <apex:pageBlockSection title="EXPENSES" columns="1" collapsible="false">
                  <p></p><b>EXPENSES</b> <p></p> {!Statement_of_Work__c.Expense_Itemization__c}
          </apex:pageBlockSection>
          
                  <p></p>
          <apex:pageBlockSection title="ONBORADING & CLOSING REQUIREMENTS" columns="1" collapsible="false">
                   <p></p><b>ONBOARDING REQUIREMENTS</b> <p></p> {!Statement_of_Work__c.Onboarding_Tasks__c}
                   <p></p><b>CLOSING REQUIREMENTS</b> <p></p> {!Statement_of_Work__c.Closing_Tasks__c}
          </apex:pageBlockSection>
          
          <apex:pageBlockSection title="WORK REQUIREMENTS" columns="1" collapsible="false">
                     <table align="left" style="width:95%">
                     <tr>
                     <th>Plan Phase:</th> 
                     <td>{!Statement_of_Work__c.Plan_Phase__c}</td> 
                     <th>Design Phase:</th>
                     <td>{!Statement_of_Work__c.Design_Phase__c}</td>
                     </tr>
                     <tr>
                     <th>Develop Phase:</th>
                     <td>{!Statement_of_Work__c.Develop_Phase__c}</td>
                     <th>Test Phase:</th>
                     <td>{!Statement_of_Work__c.Test_Phase__c}</td>
                     </tr>
                     <tr>
                     <th>Train Phase:</th>
                     <td>{!Statement_of_Work__c.Train_Phase__c}</td>
                     <th>Cutover Phase:</th>
                     <td>{!Statement_of_Work__c.Cutover_Phase__c}</td>
                     </tr>
                     <tr>
                     <th>Production:</th>
                     <td>{!Statement_of_Work__c.Production_Phase__c}</td>
                     <th>Post Production Phase:</th>
                     <td>{!Statement_of_Work__c.Post_Production_Phase__c}</td>
                     </tr>
                     </table>
          </apex:pageBlockSection>
                             
             <apex:pageBlockSection title="SCHEDULE" columns="1" collapsible="false">
                        <b>SCHEDULE</b><p></p>
                        <p></p> {!Statement_of_Work__c.Schedule__c}<p></p>
             </apex:pageBlockSection>
             
             <apex:pageBlockSection title="ADDITIONAL REQUIREMENTS" columns="1" collapsible="false">
                        <b>ACCEPTANCE CRITERIA</b><p></p>
                        <p></p> {!Statement_of_Work__c.Acceptance_Criteria__c}<p></p>
                        <b>ADDITIONAL CRITERIA</b><p></p>
                        <p></p> {!Statement_of_Work__c.Additional_Requirements__c}<p></p>    
             </apex:pageBlockSection>
             
             <apex:pageBlockSection title="ADDITIONAL SCOPE CRITERIA" columns="1" collapsible="false">
                        <b>SUCCESS CRITERIA</b><p></p>
                        <p></p> {!Statement_of_Work__c.Scope_Success_Criteria__c}<p></p>
                        <b>ASSUMPTIONS</b><p></p>
                        <p></p> {!Statement_of_Work__c.Scope_Assumptions__c}<p></p>
                        <b>DEPENDENCIES</b><p></p>
                        <p></p> {!Statement_of_Work__c.Scope_Dependencies__c}<p></p>
                        <b>CONSTRAINTS</b><p></p>
                        <p></p> {!Statement_of_Work__c.Scope_Constraints__c}<p></p>
                        <b>RISKS</b><p></p>
                        <p></p> {!Statement_of_Work__c.Scope_Risks__c}<p></p>
                        <b>CHANGE CONTROL</b><p></p>
                        <p></p> {!Statement_of_Work__c.Scope_Change_Control__c}<p></p>
                        <b>PROJECT COMMUNICATION</b><p></p>
                        <p></p> {!Statement_of_Work__c.Scope_Project_Communication__c}<p></p>
              <apex:pageBlockSection title="SIGNATURES" columns="1" collapsible="false">
                        <table align="left" style="width:95%">
                         <tr>
                         <th>Client (Owner) Name:</th> 
                         <td>{!Statement_of_Work__c.Client_Signed_By__r.name}</td> 
                         <th>Consulting Firm (Consultant) Name:</th>
                         <td>{!Statement_of_Work__c.Customer_Signed_By__r.name}</td>
                         </tr>
                         <tr>
                         <th>Title:</th>
                         <td>{!Statement_of_Work__c.Client_Signed_By__r.title}</td>
                         <th>Title:</th>
                         <td>{!Statement_of_Work__c.Company_Signed_By_Title__c}</td>
                         </tr>
                         <tr>
                         <th>Date:</th>
                         <td>{!Statement_of_Work__c.Client_Signed_Date__c}</td>
                         <th>Date:</th>
                         <td>{!Statement_of_Work__c.Customer_Signed_Date__c}</td>
                         </tr>
                         <tr>
                         <th></th>
                         <td></td>
                         <th></th>
                         <td></td>
                         </tr>
                         <tr>
                         <th>Signature:</th>
                         <td>________________________________________</td>
                         <th>Signature:</th>
                         <td>________________________________________</td>
                         </tr>
                         </table>
    
              </apex:pageBlockSection>
              </apex:pageBlockSection>
                      
            <apex:pageBlockSection collapsible="false">
        </apex:pageBlockSection>   
                   
    </apex:pageBlock>
</apex:page>


 
I have a flow that collects the date from one field, the time from a dropdown, and then uses a formula to combine the two to use to create an Event Record.

User-added image

I've used various combinations trying to get the formula to create something that can be used to populate the StartDateTime and the ActivityDateTime fields, but can't find a way to get it to work.

I have my choice stored values for time set to return miltary hours:minutes:seconds, e.g. 13:00:00

My current formula is: Text({!Tour_Date}) + " " + {!Tour_Time}

As a text formula this shows on my display text screen (that I'm using to verify my field inputs prior to using Record Create) as 2014-11-24 1:00PM, which seems to be as close as I can get as an input for the Event DateTime format.

But as soon as I change the formula value data type to DateTime, or if I add DATETIMEVALUE() around the formula above, my test sceen in the flow shows nothing for the result.

What am I missing?