Questions tagged [date]
A value that indicates a particular day. Unlike Datetime values, Date values contain no information about time
534
questions
0
votes
0answers
5 views
Import English (UK) dates into Marketing Cloud
I am trying to import a CSV with a bunch of customer information into Marketing Cloud.
The import keeps failing due to Invalid Date: 7.
I've been using English (United Kingdom) as the date format ...
0
votes
1answer
18 views
Date Field - Timezone Issues in Batch Job
I'm seeing peculiar behaviour on a Date field (not a DateTime field) when we utilize these date fields in a batch.
For instance using the code below:
endDate = Date.newInstance(startDate.Year(), 6, ...
0
votes
1answer
26 views
Problem with Date format in SOQL
I have a silly problem, when I pass Date from lightning input (type=date) i pass it as a string,
and when i creating a query with this paramiter i recived error like below
value of filter ...
0
votes
0answers
13 views
SOQL queries with date literals
I am trying to send a SOQL query to salesforce using jsforce. I would like to select all opportunities that are closing within the next year. I firstly tried to use a javascript date but I get an ...
0
votes
1answer
21 views
I'm getting this error when i'm trying to add days Error: Method does not exist or incorrect signature: void addDays(Decimal) from the type Date
if(application.genesis__Lending_Product__r.Name=='Restructured Term Loan')
{
loanAccount.loan__Accrual_Start_Date__c= systemDate.addDays(application.Deferred_Payment__c*7);
}
0
votes
1answer
63 views
How to enter date and lookup field into an object
I rewrote the code, through anonymous works.
I only have a problem with the date and field Log__c (lookup).
public class ExampleExchange {
@AuraEnabled
public static List<Exchange_Rate__c> ...
2
votes
2answers
56 views
Get records created on a specific day
I'm programming a batch that needs to mail community users if they've created their user exactly account 39 days ago.
It seems difficult to query on a specific day ...
I first tried :
Date limitDay =...
0
votes
1answer
25 views
Convert two separate fields Date and time fields to milliseconds
I have two separate fields Date and Time fields. I would like to convert these fields into seconds format.
I am using this seonds format to make google API call.
https://maps.googleapis.com/maps/...
0
votes
2answers
17 views
Automatic Date Stamp on a Stage Change
I want to add an automatic date stamp when an opportunity moves from Stage 1 to any other Stage that isn't closed.
0
votes
0answers
28 views
set default value/auto-populate required close date field when creating new opportunity
When a user creates a new Opportunity the Close Date field is required to be entered. However, the requirement is to automatically set this field to 1 date from when the opportunity is created. I ...
2
votes
1answer
82 views
extract year, month, day, from date field in a report? [closed]
I was wondering if it would be possible when creating a report to have individual columns for each portion of a created date field (column for year, column for month, column for day)? I know I could ...
0
votes
1answer
47 views
Modify Date Range
How do I modify the code below to have the week range from Thursday 12 PM Central Time Zone to the following Thursday 12 PM, so setting the Start date of the week to be Thursday and end week to be ...
0
votes
1answer
68 views
lwc convert date from text to lightning-input of type date
I have a component which is displayed in a custom data table column for a text field having date value. By default text value dueDate along with Edit icon gets displayed. When the edit icon gets ...
0
votes
2answers
31 views
Change date format in formula to MM/DD/YY
I have a formula that uses a date field that returns a date with a format DD/MM/YYYY. I need to change the format of this date to DD/MM/YY.
TEXT(DAY(ExpectedDeliveryDate__c))+"." +TEXT(MONTH(...
0
votes
1answer
51 views
Journey Builder recurring based on Date field
I have a question about Journey Builder.
I have built a journey that is supposed to evaluate contacts on a monthly basis based on specific date field.
I have configured the schedule as recurring ...
3
votes
1answer
152 views
How to output [MMMM dd yyyy hh:mm AM/PM] using Text formula on a DateTime field?
Good day StackExchange!
High level, my goal is to take a date/time value and use a formula to display it as a customer friendly long date (MMMM-DD,YYYY at HH:MM AM/PM) string output for email ...
0
votes
0answers
21 views
A Posted Solution to a lightning:formattedDateTime Problem No Longer Works
I have the same problem asked about here, where the date displayed by the lightning:formattedDateTime component does not match the date field that's its value.
I attempted the answer chosen in the ...
2
votes
0answers
33 views
Get # of days for week number X
Is there a way to get the total days or hours of each week of a month?
I am using WEEK_IN_MONTH() to get the week number but now I need something like HOURS_IN_WEEK() or DAYS_IN_WEEK() which I can ...
0
votes
2answers
67 views
Newest records for a SOQL Query
I have the Object Case and the Object Agent and I have multiple Agents created by Case. Both of them have their Ids.
Agent has a field CaseId and I want a List with the newest Agents related with a ...
3
votes
1answer
84 views
Max attribute is not working propery for input type date
Hi Currently I am facing issues in the "Max" attribute in lightning-input but max attribute is not working properly in some cases.
My requirement is to disable dates after One year of the Current ...
3
votes
1answer
131 views
Issue in Finding Difference between Date's in LWC
Currently, I want to find a difference between two dates in months in LWC.
I am getting a difference as 'Nan'.
Here is the playground link
Below is the screenshot for your reference
1
vote
1answer
47 views
Changing Date time using DateTime - format(dateFormatString, timezone)
In below execute anonymous code I am seeing a strange behaviour.
DateTime myDateTime = DateTime.newInstanceGMT(2019, 12, 30, 0, 0, 0);
system.debug('myDateTime === ' + myDateTime);
DateTime ...
1
vote
1answer
16 views
Invalid date and time error [duplicate]
I have a @restResource that's receiving a JSON payload as a string. I am taking that payload and placing it into a Map<String, Object> variable. I'm trying to save the date/time into a variable ...
1
vote
1answer
83 views
Process builder conditions when custom date/time is NOW()
Should be simple but I'm getting stuck on the formula
Building a workflow in process builder and trying to trigger an action when custom object's custom date/time field is NOW().
0
votes
0answers
25 views
Date Format of DateTime in Select/Aura Iteration
Here is the code :
<lightning:select aura:id="SelectRepport" name="PaymentType" label="repport Z" onchange="{!c.zRepportSelected}">
<option value="0">Chosse ...</option>
<aura:...
1
vote
0answers
14 views
Is Salesforce Advanced Formula Example for Business Days Incorrect?
Throughout the year we have been using the following formula field from Salesforce Advanced Sample Formula to calculate the number of business days:
This is recommended on the Salesforce Website ...
0
votes
1answer
28 views
how to write formula to get year end date based on system.today
how to write formula to get year end date based on system.today.ForExample: if i open 1/1/2020 that field will be show 31/12/2020 like that i need formula
0
votes
1answer
65 views
Convert Birthdate to Getdate
I am trying to send a message to everyone whose birthdate is in two weeks but the date is of a different format and the query thus returns 0 rows.
The query I am currently using is the following
...
8
votes
1answer
124 views
Which date format to use with inputs for the Quick Actions REST API? (INVALID_TYPE_ON_FIELD_IN_RECORD)
I'm receiving the error INVALID_TYPE_ON_FIELD_IN_RECORD when invoking a custom sobject quick action to create a record and its payload specifies a Date or DateTime field as an input value.
For ...
1
vote
1answer
27 views
Date formatting for SOQL String - unexpected output
I have '273' added as a day with the following line:
DateTime.newInstance(dStart.year(), dstart.month(), dstart.day()).format('DD-MM-YYYY');
so the output looks like '273-09-2019' - what gives?
I ...
1
vote
2answers
34 views
JSON Date field Error
I have the JSON string below that is being sent to a Salesforce Webservice:
{"Opportunity":
{"Id":"006g000000IiM5z",
"Appraisal_Date__c":"2019-11-22"}
I serialize the request into a Map and am ...
3
votes
1answer
200 views
Aura localizationservice: broken format/parse with some locales
We're having an issue with a custom-build form date input component.
The component formats Javascript date objects into user-friendly strings for user display/input, i.e. "5 May 2019", and then parses ...
4
votes
1answer
84 views
Formatting Date and TIME in French
I followed this question/Answer to format date in French:
AMPscript Date Formating for French Language in HTML emails
Following this post, I would like to know how we should add the time to the date ...
0
votes
0answers
36 views
Rendering a date via lightning:formattedDateTime
When using date.today() for a community page it shows as yesterdays date in the community. If you look up the record in the system it shows properly as today. I've seen the post about the users ...
0
votes
0answers
12 views
How can I create a VF component that follows you like the header bar?
I need a component that will follow you from page to page like the header
I need to have a visualforce component that simply shows a timestamp no matter where you are on the org.I was thinking ...
0
votes
1answer
58 views
How to use Select command in SOQL to return sysdate using a generic table or No table for from clause
For tests proposes, I need to get the current system date.
On Oracle we could use:
SELECT SYSDATE FROM DUAL
On SQL SERVER, we can use:
SELECT GETDATE()
On DB2 we would use:
Select current ...
1
vote
1answer
51 views
lightning:inputField type Date showing both Date Picker and history of dates, how to avoid showing history but show only the Date Picker?
I am using lightning:inputField with type as Date, the issue is this field shows two pick-windows 1. Date Picker and 2. Date-History picker.
Please help anyone, if you know if there is any fix for ...
0
votes
2answers
269 views
Validate Date Format - Apex
I have a lightgning component for Account Creation / update. In this component i use as input field a date field. I want somehow to validate in Apex (Component Controller) that the date the user has ...
0
votes
1answer
405 views
Calculate Months between two dates? [duplicate]
On quote whenever user specifies Start Date and End Date we need to calculate Subscription Term which should be exact months, here it should say 12 months but its showing 11.96.
Can anyone please ...
2
votes
1answer
37 views
MC Connector createdDate transformation
I believe there are some date transformations applied automatically when synchronizing records from SFDC to MC via the Connector
I am talking about Created-date on Contact records for instance - I ...
0
votes
1answer
85 views
Get all records inside a given date
I need to get all the records that are inside a given date. What I have now is giving me only one of them randomly every time I run my query. Any suggestions on how to fix that?
SELECT table1.Number ...
0
votes
1answer
72 views
Ouput date in ISO8601 date-time format
I need to output a date in ISO8601 date-time format in Salesforce using SSJS.
Salesforce is storing in format 'Thursday, 1 August 2019 5:00 PM'.
I have tried Write(current.date.toISOString()) but ...
1
vote
1answer
40 views
AMPscript: Including Ordinal Indicators In Date Formatting
I have an automated email that will be sent every month and I'm trying to get the expiry to reference the last date of the current month formatted to read 31st January, 2019 or 28th February, 2019. I'...
1
vote
0answers
39 views
AMPscript Dynamic Date MobilePush Message
Is it possible to reference a date attribute of a particular push message? As in something like:
%%[
VAR @messageCreatedTime
SET @messageCreatedTime = MessageCreatedTime
]%%
Inbox Subject Line: %%=...
-3
votes
2answers
149 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
38 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 ...
1
vote
1answer
70 views
FORMATDATE and format pattern to add year when using format pattern “M”
I have this code
SET @START_DT = "2019-08-05T06:07:08.1230000-06:00"
SET @CHANGE_DATE = FORMATDATE(@START_DT),"M","","da-DK")````
Which output format is:
august
I would like to add the ...
1
vote
1answer
260 views
SQL query to group EventDates by day of week
I'm trying to write a query in Marketing Cloud that will filter for an event (specifically a unique open) that took place on a specific day of the week. So for example, my query would answer the ...
-3
votes
1answer
135 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) + ...
1
vote
2answers
50 views
How to assign current date to a custom field in a apex controller
transact.Transaction_Date__c=Date.Today();
Above is my code. Why am i getting yesterdays date?
