Questions tagged [date]
A value that indicates a particular day. Unlike Datetime values, Date values contain no information about time
680
questions
-2
votes
0
answers
37
views
formula field called in apex class
I have a I have a custom field with formula type: Year__c ,
The formula is : LEFT(Period_YYYYMM__c , 4)
I want to use just the year from this field for a function in apex class . When I use
...
- 11
-1
votes
2
answers
51
views
Calculate the Fiscal Quarter of a Date in a Formula Field if the FY starts in Aug
As the title suggests I'm trying to identify the fiscal quarter a CloseDate of an opportunity falls in, provided that the FY starts in Aug.
I have tried this as per document: https://help.salesforce....
- 169
1
vote
1
answer
120
views
Best practices Use == or isSameDay apex date
Currently in production I check if two dates are identical in apex by doing date1 == date2
I see in the documentation that there is also isSameDay
Would you know if using == between two dates is a ...
- 96
0
votes
1
answer
25
views
How do you write DATE() with a wildcard on year?
In my flow, I need to check whether a record's date month and day match a specific date but not the year.
So, I have a basic decision item that looks like this:
{!Record.StartDate} = DateVariable
I ...
- 11
-1
votes
1
answer
49
views
Validation Rule to Restrict date within current fiscal year?
I need help creating validation rule to restrict date between the Current Fiscal year of the company.
Say, the user should be able to only select dates between Oct 1 to September 30 of the following ...
0
votes
0
answers
116
views
"The request body is either invalid or incomplete."
I'm using the analytics studio to build a dashboard right now. I put 2 reports about campaign influence, that I created via "Reports", one for customers and one for prospects. I want to put ...
- 1
0
votes
2
answers
59
views
AMPScript: Is there an easy way to have dynamic date format based on Same Month vs Different Months?
I want to create a list of events that will show event start dates and end dates. I have a data extension that stores the StartDate and EndDates. Is there an easy way to make the date format dynamic ...
- 15
0
votes
1
answer
55
views
How to use order by clause for dates
How would you go about getting the most recent date from a table?
I've been trying to use the clause order by but I get back the following error: "An error occurred while checking the query ...
0
votes
1
answer
79
views
If a record exists with the same Date as another do not create the record
I have a Salesforce/Visualforce page which allows my user to create entries out of a list of users by dragging them onto a sudo-schedule. Once the entry is created it will display some basic ...
-2
votes
1
answer
55
views
Date Parsing In Apex
I am having birthdate like this as string 'November 1, 2012' and I want to find the age pertaining to current date.
I am trying to convert first into date as like below
Date.parse('November 1, 2012')
...
- 55
0
votes
1
answer
85
views
Converting PST time to UST TIM
I am having a time like this which is in PST Time zone '2022-12-29 08:00:00' and I am trying to convert this into UST whose output has to be as '2022-12-29T16:00:00Z'
2022-12-29 08:00:00 (PST) --> ...
- 55
0
votes
0
answers
62
views
Apex Insert Date time as it is
Inorder to book appointment in FSL I am reading the available time slots for the service resource using getAppointment REST API and here is the response from API
{
"candidates": [
{
...
- 55
1
vote
1
answer
72
views
Field Formula for Soonest Date After X Amount of Days
I'm trying to create a couple of fields to calculate the eligibility date for employee benefits.
-The first one should return a date of either the 1st or the 15th of the month 60 days after Hire Date. ...
- 13
0
votes
1
answer
103
views
Format Date from Datatable selectedRows
In my LWC I have a Datatable with a column for "Date From" - below is the column configuration
{
label: 'Date From',
fieldName: 'werDateFrom',
type: 'date',
sortable: true,
...
- 333
0
votes
0
answers
41
views
How do I put a DATE type value in a String field in a Marketing Cloud data extension
I'm trying to do this sql query, but I'm getting an error when converting the type date to string.... I've tried using CAST/ CONVERT/ TRYCAST .. but I must be doing something around because Marketing ...
0
votes
0
answers
142
views
Calculate Salesforce Case response time
I'm new with salesforce formula and I have this requirement to compute the business hours with mins. in salesforce case.
what i did is that i set-up one field in case objects (data type = formula). ...
-2
votes
1
answer
86
views
AMP Script - Populate last date of the third month in DD-MM-YYYY [closed]
set @todayUS = Now(1)
set @tomorrowUS = DateAdd(@todayUS, 1, "d")
set @yesterdayUS = DateAdd(@todayUS, -1, "d")
set @threeMonthsDate = dateadd(@today, 3, "M")
set @month =...
- 11
0
votes
0
answers
33
views
Populate in my date field the latest date
I have 2 records types in my asset :
The licence with a field "expiration date" and
The module with one checkbox and one "Contract end date"
I succeed with a flow to populate my ...
- 1
0
votes
0
answers
109
views
Displaying Year in the footer of a custom salesforce email template
Question is: How do you display the current year in a Salesforce classic HTML email template? This would be where the copywrite section with the 2022 goes. This way it doesn't have to be manually ...
-1
votes
2
answers
27
views
Error in date class
I am tr4ying to concatenate two date fields. But I'm getting this error: "Date expressions must use Integer or Long"
eg: System.debug(date.today()+date.today());
- 1
0
votes
0
answers
51
views
After Winter '23 release, some orgs suddenly enabled the test run for the ICU release update
This Monday, after the Winter '23 release went live this weekend, we were surprised that suddenly the test run of the ICU Locale Formats release update was enabled.
Did more people have this happen? I ...
- 431
1
vote
1
answer
40
views
Date.parse parses weird dates with no typeException
Date.parse('30/30/2019') works different in sandboxes. Everywhere typeException is thrown as expected, but in one sandbox this date is being parsed into 2021-06-30 00:00:00.
I checked everything - api ...
- 13
1
vote
1
answer
56
views
Getting a wrong date format when getting inbox messages on Android
I'm using the react native sdk for SFMC and I have some difficulties with getting the inbox messages from the Android platform. Somehow the date format is like: Fri Sep 30 11:16:00 GMT+02:00 2022
And ...
- 11
8
votes
1
answer
199
views
Winter 23 - ICU date Formats - Date.parse
I have observed in the last few days the following (locale = en_US):
Date d = Date.parse('15/56/2023'); // run with api V55
System.debug(LoggingLevel.INFO,d);
Environment ICU enabled? ...
- 67k
-1
votes
2
answers
124
views
Can I set the field CloseDate on Opportunity to null or blank?
I know that I can use some workaround like that:
opp.CloseDate = Date.valueOf('1900-01-01');
But is there a possibility to have that field not visible for some (cloned) Opportunities? (beyond hiding ...
- 7
-1
votes
1
answer
479
views
How to get start and end date of a specific quarter
I'm looking to update the start date & end date of the specific quarter based on the year and quarter fields selected by the end user. I thought of trying with the Period object but I'm unable to ...
- 1,448
1
vote
1
answer
53
views
Remove time stamp from a Salesforce Field in Marketing Cloud
I do want to remove the time from a Salesforce field retrieved from the object CampaignMember.
I had tried this the following amspcript code in my email but I do still have errors to send it :
%%[
VAR ...
- 37
0
votes
1
answer
255
views
Report Filter Date
I am looking to filter a date to show appointment dates for only this month to todays date (so not the entire month). Is there a relative date formula i can use for this?
Thanks
-1
votes
1
answer
62
views
convert kafka epoch date to normal salesforce date
I am receiving events from kafka which has logical type date fields
"FirstDate": 37367,
"LastDate": 86367,
I am trying to convert it salesforce appectable format like below
cont....
- 1,630
2
votes
1
answer
483
views
Is it possible to use a date range as map's key and then use a date to find the entry?
I have a list of records that map to a particular date range. For eg:
1 Jan 2020 - 31 Dec 2020 -> Toyota, Aston Martin
1 Jan 2021 - 31 Dec 2021 -> Red Bull, Mercedes, Ferrari
1 Jan 2022 - 31 ...
- 313
0
votes
2
answers
483
views
SOQL to get all records with in a given date range
Below is my sample data:
I am trying to form a query where I can get records within a date range.
Date Range is start of the week to end of the week. For example I want all records that falls between ...
- 4,681
0
votes
1
answer
2k
views
Need help using IF statement in Salesforce Flows
We're moving to Flows and I need a bit of help on IF statements in Salesforce. I've tried a few variations but with the IF statement when creating a DATE formula but I keep getting “Syntax error. ...
- 5
-2
votes
1
answer
454
views
Want to validate date in LWC [closed]
I am trying to validate date in lwc. When i enter date as "0000-05-05" it show its not valid but when i enter date as "0005-05-05" it shows its valid date and apex class throws ...
- 3,773
1
vote
1
answer
382
views
Creating sObject via REST - date format
Currently, I've used the postman to make a request to standard Saleforce API.
At the Date field I inputted year only.
As I expected, that should be inserted fail for that case.
But actually, the ...
- 11
0
votes
0
answers
49
views
To filter business days and selected holidays using SAQL/Data Recipe transformations
I am completely new to Tableau CRM and trying a requirement where I need to filter business days and selected holidays in my dataset.
Here is how my data looks like-
Date Reduce days ...
- 1
0
votes
1
answer
49
views
apex date not valid error
Sorry if asking same question again but really facing the issue with the bad input date I am new to salesforce if someone can guide me how to handle leap year and bad date in apex.
If someone enters ...
1
vote
1
answer
433
views
Using Date fields in process builder as conditions
I am trying to use date fields as part of my condition in a process builder to say:
If field #1 (number) has value > 0
AND field #2 (date) is less than 30 days ago (ie. date is within the last 30 ...
- 11
0
votes
2
answers
1k
views
Changed Date in flow
I have a Record - Triggered flow , and I need to make a condition on a custom field type Date , the condition is to verify if the date is modified make a another custom field is false and make this , ...
2
votes
1
answer
260
views
Does Date.addDays() method skip the weekends based on the Org's Business Hours settings?
For example when I use Date.addDays(1) for a task's due date. I realized if the next day falls into a weekend both Sat and Sun are skipped and it adds 1 workday (which is three days count). Now, this ...
- 758
-1
votes
1
answer
483
views
Unable to see last login or the login history for some users [closed]
when i go to Setup----> users-----> i could see the list of users.
I could not see the last login date for some users and also the login history for them. Can i know the reason for it.
- 1
0
votes
1
answer
85
views
Validate records by date ranges in SOQL and apex en bulk [duplicate]
I have a custom object with two dates - start and end. When inserting multiple records, I want to ensure they don't overlap at all. Naive implementation:
global with sharing class OverlapFilter_TDTM ...
- 4,676
0
votes
2
answers
98
views
Calculating the start of a new month in SF
So essentially what I'm looking for is to be able to calculate the start of a new month. So for context, there is a checkbox that I want to clear at the start of every new month (if it's ticked ofc). ...
- 1
0
votes
2
answers
726
views
Formula field date subtraction
I have a formula field as a boolean which should return true if the date of today and enddate has less than 3 months in between and the enddate field is not empty. I dont get the correct results. ...
- 2,274
0
votes
1
answer
6k
views
Format a date in a Flow?
I used in my flow a custom field of type date which returns to me in the email action a value of the date in the form of month Daye , Yers , what I want is to have the value of the date in the form DD/...
0
votes
1
answer
348
views
Date format in lightning-input after changed input value format
An issue in Date format validation in lightning-input type Date: After I changed the input value format according to the latest Salesforce updated ICU locale format for Ireland.
The last column shows ...
- 3
0
votes
1
answer
991
views
How to set Date field to Null or Blank using flows?
I am trying to set a date field to Null when there is a checkbox set for a record.
I have tried using Formula field of type Date and setting it to Null, using process builder global constant and tried ...
- 1
0
votes
1
answer
27
views
AMPScript convert "feb" to 02
I'm looking to convert a data field value (@OPT2) from "01-Feb-22" into "01-02-22" to be displayed on a landing page.
The reason is I want to display the date in French too and ...
0
votes
1
answer
623
views
How to get the range of Fiscal years from FiscalYearSettings based on Current FIscal Year Dynamically?
I am trying to fetch the Fiscal Year Setting Records using SOQL for the fiscal years based on current fiscal year. I need few records before the current fiscal year and a few records after the current ...
- 65
1
vote
1
answer
41
views
How to Update List of Account in visualforcepage?
Iam new at salesforce, anf need your help and advice guys.
there is a list of account objec and I want to update PPDDate field (custom type date).
i can update several PPDDate at once then press the ...
- 531
0
votes
1
answer
233
views
String to Date in SQL
I have the following problem:
I imported a csv file in MC and there is a date field in it. When I create the billing_date attribute as text field, all of the csv data will be imported correctly and ...
- 1