All Questions

Tagged with
Filter by
Sorted by
Tagged with
-3
votes
2answers
47 views

How to get the Latest record created date in salesforce?

I have a field called "Date" on custom object "TestData__c". If I create a record today I need to display today date.If I create a record tomorrow I need to display Tomorrow date.How Can I achieve ...
2
votes
2answers
24 views

Formula showing Day Of Week and CreatedDate as a Text String

I am trying to create a formula field that will return the Day of the Week concatenated with the date the record was created. The end result should look like this: Tuesday - 8/13/2019 I have this ...
-3
votes
1answer
33 views

Contract End Date Formula

I've been racking my brain for about 8 hours trying to figure out how this formula works, or I guess WHY it works. DATE( Year( Contract_Start_Date__c )+floor((MONTH(Contract_Start_Date__c) + ...
0
votes
1answer
29 views

Date Formula field help

Good Day, Would like to request assistance on a formula. I am trying to capture the Day & Month of a field called Contract_Start_Date__c and then add the year today. For instance Contract Start ...
0
votes
1answer
38 views

What is wrong with my Date/time Process Builder Formula based on a Date field without weekends

I have a Task Process Builder based on Opportunity Stages. I am trying to create a formula for the date time due field based on a date field (Internal Deadline). I need the formula for the Date Time ...
0
votes
1answer
32 views

Business day formula help

The use case: I am trying to calculate a date that is 3 "Bank Business days" after the application create date. Which includes Saturday and not Sunday. The Below Formula is taking into consideration ...
0
votes
3answers
75 views

How do I set a project end date to be 6 months out from the start date?

I created a custom field called Start_Date of type date. I created another field called End_Date that I would like to default to Start_Date + 6 months. But whenever I try to do this in a formula I get ...
0
votes
1answer
463 views

Check if date is in This Week

I want to check if today is with in This Week in Salesforce formula. I tried to do this via Date() function, but there is no THIS WEEK function. If there a workaround? I don’t have a solid code, so ...
0
votes
2answers
588 views

Difference between two dates and add business days?

I have two dates, Created date and date processed. I want to find the midway between these two days but make sure the midway date lands on a business day. DATEVALUE(createdDate) + (( ...
2
votes
1answer
801 views

Calculate business days between two dates

I'm trying to create a formula that would calculate the business days between "Claim Filled/Submitted Date" and "Date/Time Closed" for claims turn time. I'm using the formula:  (5 * ( FLOOR( ( date_1 ...
0
votes
1answer
93 views

Formula - Multiply Date Field by Picklist value (Number of Weeks) - Needs to be editable

Trying to create in Process Builder. When a Lead Time is selected from a picklist then The Contract_Date__c is populated with Order Received Date * Lead Time So if you have a Contract Date of today ...
1
vote
0answers
130 views

How to Calculate the CreatedDate Day of the Week In Process Builder

I've been trying to determine in process builder what date of the week the created date is but I keep getting an invalid formula error without details on what is incorrect. If I try either of the ...
1
vote
1answer
281 views

Can we convert Picklist value into Date format?

I have picklist which has date values like 01/01/2016,01/02/2016 ..... I need to Map this picklist value to One formula(date) field. I have tried with Datevalue(TEXT(picklist_c)) in the formula field,...
0
votes
1answer
28 views

Date calculation in formula

I have created a formula field Date__c. In this date field, I want to calculate the following: Renewal_Date__c + 1year + Extension__c The value entered in Extension__c is in months. So, I have the ...
0
votes
1answer
46 views

Date subtraction formula Field

I Want to display a value using formula field such it is a time ahead of created date and Recordactive text field based on status field values to Totaldays text field. If Status=active means Today()-(...
1
vote
2answers
1k views

To set a Blank date in a Apex formula

I have a simple formula date field which I want to return a BLANK DATE (not a NULL) if the criteria is false. I tried many syntax, but all failed
0
votes
1answer
318 views

Subtracting months in Process Builder

I have a date field (datefield__c) that i want to subtract 11 months. How can I do this using formula in Process builder? I tried to use the below code: DATE(YEAR(datefield__c), MONTH(datefield__c) - ...
1
vote
1answer
253 views

Date Formula - Want a Start to End Date Formula Field

I want to have a formula field that displayes the Start Date of an event to the End Date of an event, i.e (01/01/2017 - 31/12/17) - Like this But when I try to make it like this I can't as the dash ...
0
votes
1answer
60 views

How to make a date formula which calculates booking date + current month + 3 months(90 days) in salesforce

Example: If Booking date is -> 7 June 2017, I want the formula to calculate the current month (June) + 3 months(90 days), and the formula should return 29th September 2017 Calculating as ...
3
votes
1answer
670 views

Get Difference Between 2 Dates in Months Without Exceeding 5000 Characters

I am trying to determine the variance (in months) between an actual date and a planned date. The actual date can be either before or after the planned date, and this is what is making this difficult. ...
0
votes
2answers
71 views

Help with formula field

I have a custom object called Project. Within this object I have two important date fields – Finance Expiry date (Finance_Expiry_Date__c) and Contract Expiry date (Contract_Expiry_Date__c). These two ...
0
votes
1answer
51 views

Formula to create values: FYnn when fiscal years not on calendar boundaries

I'm creating a custom campaign naming convention and I need one part of the IF statements to return a fiscal year text value equal to "FY17","FY18", etc. So, the logic is: If the date is between 7/1/...
0
votes
2answers
262 views

Can I use a formula to find total opportunity value of years past in a workflow?

I want to build a workflow around the following: (Total $ value of opportunities in the current fiscal year > $1000 OR Total $ value of opportunities in the past fiscal year > $1000 OR Total $ value ...
0
votes
1answer
13 views

Generate “Report Export Date” Value on a Report and Associate Value with Each Record on Report…Feasible?

Is there anyway to populate the date or datetime a report is exported within a report...a field value that will be associated with every record in the report? For instance could i use the a field ...
0
votes
1answer
29 views

Process will not trigger on second date

I have set up a process on builder that should trigger when "a record is created or edited" and given the following criteria : (OR(TODAY() = DATEVALUE('2016-12-8'), TODAY() = DATEVALUE('2016-12-7')))...
2
votes
1answer
542 views

Formula for writing a specific Day of Week date value?

Objective: create a List-View Button that writes the date value of the immediately upcoming Monday to a field in the selected record(s) E.g. if Monday is Dec 5, the expected output for writing a ...
1
vote
1answer
773 views

Trigger formula on specific date

I am trying to set a formula based criteria on process builder: (TODAY() = DATEVALUE(2016,11,29)) Trying to say that on a specific date, it should fire the subsequent actions. Am I entering the ...
0
votes
1answer
924 views

DateTime formula field to compare to a specific time

I am creating an entry criteria for a milestone to kickoff. A separate workflow rule populates a DateTime field (RMA_Time__c) with NOW(). When RMA_Time__c is populated and the populated time is before ...
1
vote
3answers
430 views

Formula field shows different values in list view and detail page

I have a formula field that is showing inconsistent behaviour between detail page layout and list view, report This is the formula field of datatype DATE DATEVALUE( DateTime_Field__c ) If ...
2
votes
1answer
922 views

Converting a text field to date or datetime

I am trying to convert a text field that stores a value in datetime value into a formula field of date or datetime so that I can run reports off the formula field. Text Field: Last Login: 12/30/...
3
votes
2answers
1k views

Formula for exact years (including decimal places) between two dates

I'm using this formula to calculate a person's age: IF ( MONTH(TODAY()) > MONTH(Birthdate), YEAR(TODAY()) - YEAR(Birthdate), IF (AND(MONTH(TODAY()) = MONTH(Birthdate), DAY(TODAY()) &...
2
votes
3answers
652 views

Formula Field to get previous month and year from a given date

Suppose i have createddate as 05-05-2016 then formula field 1 should be 042016 and formula field 2 should be 032016. Two Exceptional cases are: if i have createddate 01-01-2016 (January) then ...
0
votes
2answers
739 views

Formula - Format Date?

I have a formula field whose return type is TEXT and below is the formula: IF(Title_Release__c = TRUE, 'Released', TEXT(Expected_Titled_Date__c)) The result is as expected which is satisfactory but ...
2
votes
1answer
78 views

Help with Date Formula Field

I'm trying to create a Date Formula field that will check and see if the Date Value that will be placed into that field is still within the same month as another field and then if it is populate the ...
2
votes
1answer
500 views

Formula to Find the First Weekday of a Given Month

I am currently trying to create a formula field that will display the first weekday of a month. So for instance 7/1/2016 was a Friday so the field would have displayed that date. But, if it would have ...
2
votes
1answer
2k views

How to calculate duration between two dates(in months and days) using formula field?

My client wants me to write a formula field to return the duration(in months and days) between two date fields. For ex: If start date is "January 1st 2016" and end date as "December 31st 2016" then ...
3
votes
3answers
399 views

Formula works on page layout, but displays #Error! on Report

I have an issue. I have a text field to store survey completion date and time. I created a formula field to capture date only. DATEVALUE( completion_time__c) It is showing correct date on Page ...
3
votes
1answer
7k views

Process Builder - Add Minutes,Hours to Event End Date

I want to make the Event End Date as NOW()+60 Mins in process builder while creating a new Event record. But It is adding 60 DAYS even though Event End date is date/time field. How do I add minutes ...
2
votes
2answers
1k views

Formula to Calculate 10 Business Days from Created Date?

How would I edit this formula to reflect a date of 10 days days after created date? It currently covers 48 hours or 2 business days. CASE( MOD( DATEVALUE( CreatedDate ) - DATE( 1900, 1, 7 ), 7 ), 0,...
3
votes
1answer
237 views

Minimum Date Formula

Hoping this is an easy one. I have this formula in a VF page: MIN( Year(DateValue(Account.CreatedDate)), Year(Account.Source_System_Created_Date__c), Year(DateValue(Account....
0
votes
1answer
1k views

Extract year from date field

I have a custom field with date type. I want to use just the year from this date field for a calculation. I want to use to update a field value. I am unable to get only the year from the date field. I ...
3
votes
4answers
3k views

Formula that returns the current day of the week

In Salesforce Trailhead there is one Challenge available. Please find the challenge description below To complete this challenge, use some of the strategies and function you learned in this unit to ...
1
vote
1answer
46 views

Number of the Year's week formula stopped working

I had a nice formula that was counting the week of the year, but as we approach the end of year it has stopped working. It now shows "1" in December. Sample versions: CEILING((( Date__c - DATE(...
3
votes
1answer
116 views

End of the year date formula

Need some help with a formula. I have a start date field that the users have to fill out ( ex. 10.05.2015 ) but i need a date field to automatic fill out an End of the year date. It would always be ...
1
vote
0answers
35 views

Converting American Date format to a Date Using a Formula

I'm converting an American Date format string to a Date using the following Formula. For example, this will convert a String like "9/25/2015" to an actual Date field that can be used in reports, list ...
0
votes
2answers
688 views

Formula to put a date together seperatly Fields “Month” and “Year”?

In an custom Oject, that is filled with external market development data I got a picklist field "Month" (Picklist: 1,2,3,4...12) and a picklist field "Year" (picklist: 1990, 1991, 1992... 2020). Each ...
1
vote
0answers
101 views

Convert Date to Datetime Formula

I need to convert the following formula to DateTime based. Can you assist? IF(C1_Date__c = TODAY()-1, 1, 0) + IF(C2_Date__c = TODAY()-1, 1, 0) + IF(C3_Date__c = TODAY()-1, 1, 0) + IF(C4_Date__c = ...
1
vote
0answers
94 views

Determining due date (with hours) with Start date, length in hours and business hours in salesforce formula

On the case Standard object, i would like to determine the due date when the case is created. Business hours is active (9AM to 6PM, monday to friday, no exception, no holiday),and i've got Different ...
3
votes
3answers
6k views

Date Formula to Calculate date excluding weekends

I have a formula that is calculating the date from another date field + number of days and returning a date. test census dates field = Confirmed_Enrolled_Date__c + 16 I want to exclude weekends ...
0
votes
1answer
900 views

Date Formula Field Problem

I have two dates fields as (Procedure_Code_Date__c and Service_Date_To__c ) on my object.And i want to make a new formula field for if one of the dates is null then other one will populates or if ...