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