Stack Exchange Network

Stack Exchange network consists of 175 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
0answers
13 views

Accept date in MM/DD instead of dd/mm/yyyy on record detail page [closed]

I have requirement to accept date only in MM/DD format on lead object. The year should not be visible to user. PFB screenshot. Please let me know whether it is possible or suggest any workaround for ...
0
votes
1answer
24 views

Apex Date Parse Invalid Date in IE11 - Valid In Chrome

I have a string searchStartDate coming from an input field on a VF page. The input is 03/20/2019 Once passed to the apex controller I debug the string before parsing it. In IE11: 08:02:13:041 ...
0
votes
1answer
29 views

<lightning:input type=“date” validation

I need to put a validation on lightning input field date. It is a date of birth field and it should not accept date beyond system.today(). Basically the validation will be date_Of_birth > Today() , ...
0
votes
1answer
33 views

Issue with apex:input datetime

I have a page where a patient enters the appointment date for consulting, I m showing a dateTime input fields as <apex:input type="datetime-local" value="{!appointmentDate1}" styleClass="bRadius ...
0
votes
1answer
17 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
42 views

How to send date from web to lead to datefield salesforce

I try to pass a date from a web2lead form to a date field, but the field stays empty. Travel date in: <span class="dateInput dateOnlyInput"> <input id="00N1t00000K2yXV" name="...
0
votes
1answer
21 views

Converting a String to a Date with Date Format YYYYMM

I kind of stuck on this one. Basically, we have a string that is actually a date with a format YYYYMM. For example, 201901. I wanted to convert this into a date record, but I found out that we could ...
-1
votes
1answer
23 views

Show Date selected in Filter in separate text boxes [closed]

There is requirement to show Date range selected in seperate text boxes. For example if i have a Select list filter for Dates and i have selected date range between 01/01/2019 and 12/01/2019, i also ...
0
votes
1answer
46 views

How to separate The Day, Month and Year attributes using SQL _Open query in salesforce marketing cloud?

I have creating TestDE Data extension using these attributes like SubscriberKey, AccountID, EventDate, Date, Month, Year attributes. And Created with same attributes using Target Data extension. Now ...
0
votes
1answer
171 views

Apex convert string mm/dd/yyyy hh:mm:ss to standard system date (yyyy-mm-dd 00:00:00)

I am trying to convert string from google docs "1/16/2019 11:52:38" to standard system date "2019-01-16 00:00:00". I was able to achieve that using substring method but I am pretty sure there is a ...
0
votes
1answer
25 views

How to add only business days

I have a problem with adding days when creating Task. I have a simple apex code newTask.ActivityDate = Date.today().addDays(5); But what i need to do is to count only business days. Thanks for any ...
0
votes
2answers
85 views

Convert String Date to Date in Apex

I am using an SOQL in a webservice that is querying the Contact object based on the BirthDate field. The webservice request has the date in the format of 'yyyy-MM-dd',i.e.,1962-01-29 as an example. I ...
0
votes
1answer
20 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
119 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
106 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
87 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
31 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
82 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
70 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
53 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
56 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
38 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, ...
1
vote
1answer
27 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
27 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
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 ...
1
vote
2answers
457 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
2answers
207 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
34 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
59 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
1k 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
335 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
43 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
68 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
698 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
64 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
402 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
147 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
85 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
170 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("...
3
votes
0answers
124 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
124 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
313 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
65 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
173 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
121 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
30 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 ...
5
votes
2answers
8k 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
369 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
28 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 ...