Skip to main content

Questions tagged [createddate]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
35 views

Roll-up Summary field filter criteria YEAR()

I have a roll-up summary field on a custom object and I want to use a filter criteria to show only records that have been created for the current year. This is not on a report, but when I am actually ...
jacques661's user avatar
0 votes
2 answers
66 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 ...
Thomas's user avatar
  • 2,310
0 votes
1 answer
144 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, ...
Aarón Henríquez's user avatar
-1 votes
1 answer
638 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 ...
user11880836's user avatar
0 votes
1 answer
69 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 ...
Sergio Pedraza J.'s user avatar
0 votes
0 answers
57 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 ...
Pavithra G C's user avatar
0 votes
2 answers
774 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 ...
GroundToCloud's user avatar
1 vote
1 answer
1k 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,...
Vitalii Dehnerys's user avatar
2 votes
1 answer
514 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 ...
Andreas86's user avatar
  • 357
0 votes
2 answers
349 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 ...
Andrew123's user avatar
0 votes
1 answer
2k 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. ...
Kiran Kulkarni's user avatar
3 votes
2 answers
2k 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 =...
Alexis MASSON's user avatar
2 votes
2 answers
2k 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....
Mar Andrés López's user avatar
6 votes
2 answers
6k 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 ...
DarkSkull's user avatar
  • 1,749
0 votes
2 answers
562 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 ...
Sharmila's user avatar
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 ...
Sharmila's user avatar
0 votes
2 answers
894 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 ...
Souvik Banik's user avatar
0 votes
1 answer
485 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....
jlh123's user avatar
  • 9
1 vote
2 answers
4k 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 ...
SFDC's user avatar
  • 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 ...
curdual's user avatar
  • 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(); ...
Steel Reserve 211's user avatar
2 votes
1 answer
5k 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. ...
Arthlete's user avatar
  • 4,957