Questions tagged [createddate]
The createddate tag has no usage guidance.
21
questions
0
votes
2
answers
41
views
Aggregated result error: Unexpected token 'createddate'
I have the following Aggregated SOQL
List<AggregateResult> groupedSpotOnEs = [SELECT my_application__r.numbers__r.Id eSId, status__r.name status, COUNT(Id) recordCount
...
- 2,294
0
votes
1
answer
65
views
How to Change CreatedDate = LAST_N_DAYS:N in a query to a custom setting variable
I am trying to change a hard coded created date time range from a query to a custom setting. When applying the custom setting variable, the list return empty. Here is the original query:
SELECT Id, ...
-1
votes
1
answer
140
views
Is there a way to know if LastModifiedDate field was change since the creation?
I have a requirements where I need to know if the record was never been updated since the creation. I tried comparing the lastModifiedDate or SystemModStamp and createdDate if equals, however they ...
0
votes
1
answer
59
views
How can I use Test.SetCreatedDate on a Child Object and get that value on a Roll-Up Summary Field Problem? [duplicate]
Context:
I have a child object Child__c that has a parent Parent__c object. The Parent__c object has a Roll Up Summary field that displays the Minimum Created Date of all the Child__c records ...
0
votes
0
answers
43
views
Unable to use createddate in picklist field default value formula editor
I am trying to populate a default value in a picklist field by using below formula:
IF((DATEVALUE(Createddate) - Manufactured_Date__c)<365,"Yes","No")
I am getting an error ...
0
votes
2
answers
456
views
Flow formula not displaying the CreatedDate when record is created but displays when record is updated
Use Case: When an Opportunity is created or updated, standardize the Name of Opportunity
I created a Record Triggered Flow on Opportunity.
The Name populates correctly on Update but on Creation of a ...
- 845
1
vote
1
answer
819
views
Get number of records created per each of last 12 month in apex
I need to query Contacts which were created by the current user per each of the last 12 month and map them by month when they were created.
So I need Map<String,Integer> (Map<Month,...
- 1,503
2
votes
1
answer
407
views
Unable to Set CreatedDate only on Knowledge__kav
This question relates very much to Unable to Set Created date even after enabling Set Audit Fields
However, my problem is specifically related to the Knowledge__kav SObject.
I'm trying to import ...
- 347
0
votes
2
answers
304
views
Use field value with LAST_N_MONTHS
I am trying to accomplish something like the following:
[SELECT Id, CustomMember__c, CreatedDate
FROM CustomObject
WHERE CreatedDate = LAST_N_MONTHS:CustomMember__r.CustomLevel__r.CustomPeriod__c
...
0
votes
1
answer
1k
views
Unable to see created date in the mapping while importing data for lead object using data loader
I am using a Sandbox account to load data into the Leads object from a CSV via the data loader. However, I am unable to see the created date, last modified date (Audit fields) in the mapping window. ...
3
votes
2
answers
1k
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 =...
- 988
2
votes
2
answers
1k
views
CreatedDate of new record (Time)
My Org is set to GMT+1 which is my timezone. (Stated in the Company Information).
I have created a record at 11:30 am but when I retrieve the CreatedDate field it says that it was created at 10:30 am....
- 167
6
votes
2
answers
5k
views
Who created the Lightning Web Component?
Is there the possibility to query Lightning Web Component as for every other metadata (apex class, visualforce, etc...)?
I see them on VS Code but I cannot know the CreatedBy, CreatedDate and the ...
- 1,679
0
votes
2
answers
556
views
Issue in workflow field update based on created date
I am not able to understand why field update is working differently for these two cases.
Workflow field update:
ObjectCase
Field to UpdateCase: Target Date
Field Data TypeDate
Re-evaluate Workflow ...
- 33
0
votes
1
answer
2k
views
Difference in Case Created Date in UI and System Backend
created date on case UI is displaying 5/9/2018 date but in backend created date is showing value 6/9/2018 When I am querying through developer console. I have one workflow rule to calculate Target ...
- 33
0
votes
2
answers
857
views
CreatedDate is not working dynamically
String s = 'LAST_N_DAYS:7';
Date d = date.valueOf(s);
List<genesis__Applications__c> appList = [SELECT Id,Name,Branch_Name__c FROM genesis__Applications__c WHERE createDdate <= : d];
Not ...
- 11
0
votes
1
answer
467
views
Formula field on opp using created date, record types, profiles, and multiple stage names
This formula works for all my requirement except the underlined part:
IF( AND(RecordType.Name = 'Solutions',
DATEVALUE(Account.CreatedDate) <= TODAY() - 10,
CreatedBy.Profile....
- 9
1
vote
2
answers
3k
views
Difference of last modified date and created in seconds- formula field
When a record is created and trigger executes (after insert)- updating a field, I want to calculate the time difference between the last modified date and the created date in seconds. If it's greater ...
- 461
3
votes
0
answers
1k
views
CreatedDate Not Available as Mapping Option in Salesforce Data Loader When Inserting New Records
There's a need for me to load records in our SF sandbox wherein CreatedDate standard field in Case object must be inputted manually in csv file, instead of the system automatically setting itself. I ...
- 315
3
votes
3
answers
3k
views
setCreatedDate Not Working, CreatedDate is Null in Debugs
SetCreatedDate is not working, CreatedDate is null in the debug logs. What gives?
@isTest
public class PurgeOldCats_Test {
static testMethod void PurgeOldCats() {
Date today = date.today();
...
- 1,068
2
votes
1
answer
4k
views
Filter Reports by the Time of their CreatedDate
I figured that the CreatedDate will not show the time in the reports section.
So I made a DateTime formula field to take the value from CreatedDate. Now this shows the time value inside the reports.
...
- 4,855