Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [date]

A value that indicates a particular day. Unlike Datetime values, Date values contain no information about time

0
votes
1answer
7 views

How to display Date time field without showing the 00:00:00 Time when we reference it in the Apex code?

We have a S-control button which sys SendAttendancelist. The S-control calls the apex class Classobj in that we have a email that is sent out from apex while executing it sends out email with few ...
0
votes
1answer
25 views

String ('yyyy-MM-dd') to date using date.parse returns ('yyyy-MM-dd hh:MM:ss')

I am trying to output a date type with the format yyyy-MM-dd, but. not as a string type. I can create the string just fine. // First I output 2018-12-01 00:00:00 as a date currentDate = Date.today()....
0
votes
1answer
37 views

Calculate time difference between two date time fields

I have a process builder by which I am calculating the time difference between NOW() and another Case object date field. My formula goes like this Time_Spent__c = NOW() - Start_Time__c However ...
0
votes
1answer
35 views

How to get server's current date in lightning component without using apex

I have a lightning component that checks if a field date has passed the current date. The problem is that the current date is based on javascript new Date() object, so the user can change the date on ...
1
vote
1answer
19 views

Optional webService parameter in apex

I have a apex webservice with "data structure" made of webService attributes. In request data, i have: global class GetRequestData{ webService Date From; webService Date To; webService ...
0
votes
1answer
27 views

Wrong date when converting datetime value to date field

I am using the REST API for creating a new Task record, including an Activity Date in the format YYYY-MM-DDThh:mm:ssZ. My current timezone is UTC+1. When submitting a date in the first hour of the ...
1
vote
0answers
25 views

Salesforce Contracts - Testing on Contract term/End Date

I have a class that is looking for contracts 30 days before the end Date. My problem is i am trying to build a test for this class, and in that i'm trying to create a contract where the End Date is ...
2
votes
1answer
29 views

Adding days and then business days to a datetime field

Here is what I am attempting to do. I have a date on a custom object Deal__c. The date is Asset Management Close Date (Asset_Mgmt_Close_Date__c). The sidecar__c object is created with a master-...
0
votes
1answer
34 views

How to check date field with set of dates?

I have list of dates and I have stored them in a set. List<Account> a=[select id,duedate__c,overduedate__c from account]; Set<Date> sdate=new set<date>(); Set<Date> s1date=new ...
0
votes
3answers
26 views

Formula field value for old records and another value for new ones

I have formula fields which calculates the net value and total value for sales order object, I want to change these formula fields values but not affect the old value for sales order which is packed, ...
0
votes
1answer
21 views

Set Text 'Not Attempted' in Date field

Is it possible to input a default 'text' to a Date Field. which will change to a date as soon as the person attempts something
1
vote
1answer
23 views

Assigning operators for Date fields and comparing with today(), Scheduled Apex Code

Exam_Date__c = 01/01/2018, Expiration_Date__c = 01/31/2018 (usually 30 days gap) I want to send an email 7 days prior to expiration, on say eg. 01/25/2018, likewise. I used the following formula in ...
0
votes
0answers
16 views

Cumulative amounts from custom fields in SalesForce based on revenue schedules

I'm trying to create a rolling formula which renders a a specific field for the first five months and then , renders the normal revenue schedule amount after that. Every schedule ishadcorded as a 12 ...
0
votes
1answer
31 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 ...
1
vote
2answers
163 views

Lightning Component - Date formatting not consistent with standard UI

I am using lightning:datatable to render data including dates. My date column definition looks like: { label: 'Expiration', fieldName: 'ExpirationDate__c', type: 'date'} The date in the table is ...
0
votes
0answers
33 views

MAKE LIST CONTAIN 6 DATE FORMULA FIELD

I have list of Plan Date and Reminder Date (14 days before Plan Date). But, both of the fields stop counting after December 2018. I use Date Formula Field on Reminder Date. How can I make it ...
0
votes
2answers
83 views

How to pass Date dynamically to newInstance method of Datetime

i want to pass date into newInstance method of datetime class then i will get date of week.when i have given static date it's working fine but when i try to pass dynamically i am getting error please ...
0
votes
1answer
32 views

Anyone know how to remove/hide the [ 00/00/0000] Date from the date input field?

I'm just wanting to hide/remove todays date at it serves no purpose in my form any idea how I do this?
0
votes
1answer
43 views

DLRS - SOQL Error and returning text

I am trying to create a rollup field using the DLRS tool. However, I am running into multiple problems. Ideally, I would like to have my field find the most recent activity date and return the ...
1
vote
2answers
32 views

Looping through all entries using a Primary_key, Validating and Updating the corresponding field Values

Exam is an object. It contains the following fields - exam_name(String), exam_state(picklist), exam_date(date), expiration_date(date) 'exam_name' is an AutoNumber(string) field (starts from 1 and ...
0
votes
3answers
318 views

How to remove time from date?

The following code returns the time of the current date: System.debug('Current date: ' + Date.today().toStartOfMonth()); Output: 2018-08-01 00:00:00 How to remove time from date?
0
votes
3answers
124 views

Merge Date & Time field in to datetime field using formula field

We have to separate fields to pick appointment date & appointment time in Custom object. Now we have to filter out appointments between two dates (w/ time), so I need to compare appointment date &...
1
vote
1answer
36 views

BusinessHours and scheduled dates

I am trying to create a payment schedule off of a input field DATE. If the date falls on a Weekend or on a Holiday then I want to move the payment date to the next open business day. I was using the ...
3
votes
1answer
52 views

Why Datetime and Date class don't have more parse options for various Datetime/Date string formats

From documentation: Date Class: parse(stringDate) Constructs a Date from a String. The format of the String depends on the local date format. Datetime Class parse(datetimeString) ...
2
votes
1answer
280 views

How to properly handle dates returned from REST API

So it appears that when returning a DATE field from the REST API, that salesforce does NOT convert it to UTC (Doesn't return any time-zone information, just a YYYY-MM-DD string. Instead it returns ...
0
votes
3answers
58 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 ...
2
votes
2answers
219 views

how to get the date and time format that you want in apex?

I have these lines of codes in my test class: Test.startTest(); String sch = '0 0 23 * * ?'; String jobId = System.schedule('Delete Batch Donation Logs', sch, batchDeleteLogs)...
2
votes
1answer
106 views

Date.ValueOf(TimeStamp) Changes TIme of Original DateTime Field. I'm Confused Why?

I've noted very strange behaviour in some Apex code I'm running. If I use the Date.ValueOf() function on a datetime. If I then print out the DateTime afterwards the hour/minutes of it have changed to ...
2
votes
1answer
54 views

DateTime Vs. Date Flow To ProcessPlugin

I find this to be odd, not sure if this is a known issue or if it is something I just have to convert but I have a flow that calls a apex process plugin class. The flow takes a variable of type Date ...
1
vote
1answer
76 views

Determine if today is between 2 dates AMPScript

I am trying to set a flag based on today being between 2 hard set dates. EX: SET @today = Format(Now(), "MMMM d, yyyy") SET @startDate = Format("2018-07-18","MMMM d, yyyy") SET @endDate = Format("...
2
votes
0answers
72 views

Moment JS but for Salesforce Apex

Are there any open source libraries similar to Moment JS but for Apex? Reference: Moment JS
0
votes
1answer
100 views

Is there a limitation of date value while parsing in apex

There seems to be some parsing limitation on string dates in apex. When I am doing the following it throws a system exception saying invalid date: String s = '12/31/5000'; Date.parse(s); However ...
0
votes
1answer
165 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 ...
1
vote
1answer
63 views

Best way to standarize datetime formats in Lightning framework based app

I want to standarize datetime formats in my lightning app. My requirement is datetime display format based on Salesforce user locale settings. One possible approach that is based on static locale -> ...
0
votes
1answer
98 views

How to filter a objectlist in javascript by date

I have lightning controller in were I want to filter a list based on a datefield. I tried the following but end up with an empty list: My list has 2 records: serverList[0].Startdatum__c = 1-12-2018 ...
2
votes
1answer
101 views

Why do I get a Parse error on date field

I have the following simple query but i am getting a parsing query error, any ideas? SELECT startDate__c FROM invoice__c WHERE startDate__c.month() = 3 startDate__c is a date field. No errors if i ...
0
votes
0answers
25 views

Remove Timestamp from date picker field in EDIT mode

<apex:input styleClass="input-text-center" value="{! data.offerDate }" size="10" id="demo" onfocus="DatePicker.pickDate(false, this , false);" Above code is displaying the date picker for chrome ...
4
votes
2answers
4k views

Lightning:input type=“date”: how to change the date fomat - Summer'18

I'm trying to change date format of this component but I dont find any attribute (like ui:inputDate has) to change the date format. <lightning:input type="date" name="input8" label="Dates" value="...
0
votes
1answer
207 views

<apex:input type=“date” /> Not displaying date picker in Internet Explorer

<apex:input type="date" styleClass="input-text-center" value="{! data.offerDate }" rendered="{! IF( AND( data.isField = true, data.isDateField = true ) , ...
1
vote
1answer
26 views

Comparing Dates - Date.ValueOf() seems to not output correctly - returns 01:00:00

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 ...
0
votes
2answers
154 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) + (( ...
1
vote
2answers
260 views

Convert String into formated date

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 ...
0
votes
1answer
18 views

identify the last 2 weeks of the last quarter month

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 ...
-1
votes
1answer
22 views

Validation rule getting quarterly months

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(...
0
votes
1answer
18 views

Validation rule Not working properly

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( ...
0
votes
0answers
16 views

Dynamic Word in SMS [duplicate]

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 @...
2
votes
1answer
219 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
2answers
129 views

Is there a way in process builder to check if a date is set and if so, if it is greater than something?

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) ...
0
votes
1answer
28 views

Get previous month date to string no day

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 ...
1
vote
1answer
120 views

Null check for Date field on VF Page

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