date's questions - English 1answer

433 date questions.

Maybe I'm misunderstanding Date.ValueOf() - but I'm not expecting this behavior... I'm was thinking the dates would be the same. List<Limits__c> mostRecentBatch= [select id, lastModifiedDate ...

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) + (( ...

I have a string like this : 10/12/1990 that is supposed to be a date. I need to convert it into a date like that : 1990-12-10 How can I do that ? I tried a lot of things like converting it ...

I do not want the user to save the CloseDate as the last 2 weeks of the last quarter month. for ex. March 16-31 / June 16-30 / Sept 16-30 / Dec 16-31 Currently I am trying to use a validation rule ...

I am trying to get only the months March,June,September,December. Not sure why this isn't working, I use Ceiling which gives the rounded estimate. OR( CloseDate = DATE(YEAR(TODAY()), CEILING(MONTH(...

My validation rule, I am playing around. Should activate only when June 15/2018 or June 16 2018. But it activates for any date. Not sure why. OR(ISPICKVAL( StageName , "1 - Prospect"), ISPICKVAL( ...

How can I update with a blank date via the REST API? Do I need to "allow NULL values" someplace? I'm having trouble doing an upsert when I have a blank date value. I'm syncing with MySQL so it is ...

I will need to send a SMS for the first time and I will need to have on it one dynamic word, a date. I'm using AMPScript to do that but all my tentatives fail. e.g See more information on %%[ SET @...

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 ...

I am trying to implement some form of attribution, where there are two cases: Date has not been set (i.e. this is the first opportunity) Date has been set (i.e. this is not the first opportunity) ...

I printing out a date field, and normally the format is based on the user local setting (i am using french settings). the problem is that in chrome browser, the format is correct 'DD/MM/YYYY', but in ...

New to salesforce and apex, was wondering if there was a good way to get a date in this format: "201804" would be what the function would return currently. Essentially the date last month without ...

I need to create a custom field on my Contact object that records the date of the very first call that has happened with a Contact record. I thought about creating a formula field on Contact, and ...

How do I check if a Date field is null? Below is the code: <apex:outputText label="Date:" value="{0, date, MM/ dd/ yyyy}" style="text-align:center;" > <apex:param value="{!care....

I have two text field: One normal text field that accepts numbers. <apex:inputField value="{!FinancialAssCont.Down_Payment__c}" styleClass="form-control downpaymentAmount" onblur="...

I've been trying to store 'Date' via API, but somehow it doesnt work I have created new field in profile management, called 'prospect_date' If I create new subscriber, pass all attributes via API ...

I want assign a date value into a WHERE clause of query This is my date Date myDate = System.Today().AddDays(Integer.valueOf(Deal_Expiration_Batch_Settings__c.getInstance()....

what is the difference between campaign member "Member First Associated Date" and campaign member "Created date"? Object: Campaign Member

In visualforce page which use apex:repeat, and also for client side sorting uses datatable.js. A field column with date type is shown. Also the page allows inline editing, on successful edit it will ...

I'm encountering some issues when attempting to create an opportunity using the python library simple salesforce. I've verified that CloseDate is a Date Type field. With the simple salesforce ...

I've got a date string coming in like so: String str = 'Thu Jan 14 2016 23:29:58 GMT+1100 (AEDT)' It's always in that format, but neither Date nor DateTime can .parse or take .valueOf the string. ...

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 ...

The visualforce page uses a date picker which should show data only on dd/MM/yyyy format. When selecting the date and clicking save button, the date string is parsed using Date.parse and the date is ...

I'd like to build in some logic based on the weekday (e.g. Monday, Tuesday, Wednesday) of a given date. How can I identify the date, using either formulas or Apex code?

My boss wants me to auto-populate a custom date field with the date of the oldest open activity that is logged for that specific record. For example, if I have 3 future (open) tasks scheduled with a ...

How do you set the .format() method to create a two digit month and day? I have tried this myDate.Format('dd/MM/YYYY') The .format() method has no example of this on the support page. https://...

I am getting a CPU timeout from my loop. I have checked the debug logs and my start and end dates have the correct dates in them. I have tried setting the condition to be dtoday.adddays(3) just as a ...

In Lightning component I have attribute and input for date: <aura:attribute name="myDate" type="Date"/> <!-- ... --> <ui:inputDate aura:id="my-date" labelClass="slds-form-...

I have a custom salesforce object with a Date field. I am creating a new object of this type in a Lightning component, and trying to push this to the server. The objects are stored in a component ...

I have been struggling to change the date format to US locale time. I tried so many methods but if fails at some or other scenario. The issue is I cannot say which Locale the client will be using. ...

What are the minimum and maximum valid dates in Salesforce? What is the valid date range in Apex, SOQL or SOAP API? It is hard to find anything in the documentation

I'm trying to run a report and group them by 30, 60, 90 days last activity date. Do I filter by 30, 60, 90 day or how should i do this?

what is 1.8 in this expression. I have seen people using now() + (-1.8) or now() + (1.8) for making 24 hours difference. What exactly is 1.8

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 ...

So I know I can format dates like <apex:outputText value="{0, date, MMMM d',' yyyy}"> <apex:param value="{!contact.Birthdate}" /> </apex:outputText> and this outputs e.g. ...

If a created datetime is 01/26/2018 15:00:00, is there anyway that I could extract time as 3:00 P.M EST without using "TZoffset" based on the users logged in location.

I know that you can use daysBetween() for two Date objects, but what would I use to calculate the elapse time in seconds between two DateTime objects?

Sometimes after we have merged two cases the preview of emails on top of the case does not show the most recent email as first on the list. The same issue happens when we go and look at the email ...

For a custom object, I have two date fields : start date and end date. I want to make sure the end date is greater than start date. As per https://help.salesforce.com/articleView?id=...

Using salesforce CPQ I have set up a sales process which includes selling a service that can only be sold on dates that have not be scheduled before. I have already created a table that includes dates ...

I tried the same formula which is given in https://developer.salesforce.com/forums/ForumsMain?id=906F00000008vsfIAA with my fields substituted(added 36 months in my case) and I got an error saying Mod ...

I have an issue with Querying a record in a unit test with a custom set createdDate using the method Test.setCreatedDate(); static testMethod void test() { Account a = new Account(name='myAccount'...

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,...

How to convert datetime field to date field? Hi All, This is custom field of datatype : LightiningEd__Stage_change_from_Prospecting__c (Date) but Closeddate is ...

We are performing an apex callout from Salesforce to a SOAP based webservice and it requires us to pass a date in the following format: MM/DD/YYYY (note: this should be date datatype). When I am ...

I'm using a simple SQL query to get DAY, MONTH, YEAR out of a Date field (BIRTH_DATE) in Automation Studio (of marketing cloud). SELECT CUST_CODE , EXCLUDED_FROM_NPS , BIRTH_DATE , DATEPART(DD,...

Looking proper solution to hide past date in salesforce lighting. <lightning:input type="date" label="HIDEPAST" value="{!v.hidePast}" name="hidePast" /> I have checked with the following post: ...

I've created an opportunity, revenue, account, accountplan dataset. On the opportunity is a highly complex revenue logic so we decided to have a revenue field for each month. To get all those objects ...

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 ...

Looking to create a formula field that will pull 4 different dates from 4 different fields and display in one field. I put the code below, but I'm getting an error. How can I fix it? Error: Error: ...

Related tags

Hot questions

Language

Popular Tags