How to retrieve the correct Account records from SOQL query?Return more than 2000 records (SOQL)Using a specific dynamic date in a SOQL query where clauseQuery Optimization for Bulk data using a Formula field in the WHERE clauseSOQL query with inner query doesn't recognize understand the relationshipSOQL Query to compare dates on child object recordsSOQL query in Visualforce page returning only first 250 records when text area (long) is included in queryHow to get more than 2000 records from custom object?Async SOQL Query - Insufficient_Accesshow to check if an account has more than 100 casesNot all records returned in SOQL Query
count number of files in directory with a certain name
Beginner's snake game using PyGame
Can a non-EU citizen travel within the Schengen area without identity documents?
If Sweden was to magically float away, at what altitude would it be visible from the southern hemisphere?
The qvolume of an integer
Looking after a wayward brother in mother's will
Is floating in space similar to falling under gravity?
How crucial is a waifu game storyline?
The deliberate use of misleading terminology
Is having a hidden directory under /etc safe?
Term for checking piece whose opponent daren't capture it
Uncommanded roll at high speed
What does "Marchentalender" on the front of a postcard mean?
What are the problems in teaching guitar via Skype?
Could IPv6 make NAT / port numbers redundant?
Mother abusing my finances
What does the behaviour of water on the skin of an aircraft in flight tell us?
Can non-English-speaking characters use wordplay specific to English?
How to detach yourself from a character you're going to kill?
How to properly maintain eye contact with people that have distinctive facial features?
Why does the UK have more political parties than the US?
Get LaTeX form from step by step solution
Modern approach to radio buttons
If a problem only occurs randomly once in every N times on average, how many tests do I have to perform to be certain that it's now fixed?
How to retrieve the correct Account records from SOQL query?
Return more than 2000 records (SOQL)Using a specific dynamic date in a SOQL query where clauseQuery Optimization for Bulk data using a Formula field in the WHERE clauseSOQL query with inner query doesn't recognize understand the relationshipSOQL Query to compare dates on child object recordsSOQL query in Visualforce page returning only first 250 records when text area (long) is included in queryHow to get more than 2000 records from custom object?Async SOQL Query - Insufficient_Accesshow to check if an account has more than 100 casesNot all records returned in SOQL Query
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
In account record I have a custom myDate__c field of type date.
I need to retrieve all Account records where myDate__c is older than 45 days.
I've tried with the following query:
SELECT id, name
FROM Account
WHERE myDate__c <= today() - 45
However I received a warning message:
Date and number are incompatible types
How to change my query to retrieve the correct Account records?
I need only SOQL. No Apex.
soql query date
edited 5 hours ago
Jackson Chen
1,3781322
asked 8 hours ago
sfdcadmdevsfdcadmdev
61
New contributor
sfdcadmdev is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
In account record I have a custom myDate__c field of type date.
I need to retrieve all Account records where myDate__c is older than 45 days.
I've tried with the following query:
SELECT id, name
FROM Account
WHERE myDate__c <= today() - 45
However I received a warning message:
Date and number are incompatible types
How to change my query to retrieve the correct Account records?
I need only SOQL. No Apex.
soql query date
edited 5 hours ago
Jackson Chen
1,3781322
asked 8 hours ago
sfdcadmdevsfdcadmdev
61
New contributor
sfdcadmdev is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
In account record I have a custom myDate__c field of type date.
I need to retrieve all Account records where myDate__c is older than 45 days.
I've tried with the following query:
SELECT id, name
FROM Account
WHERE myDate__c <= today() - 45
However I received a warning message:
Date and number are incompatible types
How to change my query to retrieve the correct Account records?
I need only SOQL. No Apex.
soql query date
edited 5 hours ago
Jackson Chen
1,3781322
asked 8 hours ago
sfdcadmdevsfdcadmdev
61
New contributor
sfdcadmdev is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
In account record I have a custom myDate__c field of type date.
I need to retrieve all Account records where myDate__c is older than 45 days.
I've tried with the following query:
SELECT id, name
FROM Account
WHERE myDate__c <= today() - 45
However I received a warning message:
Date and number are incompatible types
How to change my query to retrieve the correct Account records?
I need only SOQL. No Apex.
soql query date
soql query date
edited 5 hours ago
Jackson Chen
1,3781322
asked 8 hours ago
sfdcadmdevsfdcadmdev
61
New contributor
sfdcadmdev is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 5 hours ago
Jackson Chen
1,3781322
asked 8 hours ago
sfdcadmdevsfdcadmdev
61
New contributor
sfdcadmdev is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 5 hours ago
Jackson Chen
1,3781322
edited 5 hours ago
Jackson Chen
1,3781322
edited 5 hours ago
Jackson Chen
1,3781322
1,3781322
asked 8 hours ago
sfdcadmdevsfdcadmdev
61
New contributor
sfdcadmdev is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 8 hours ago
sfdcadmdevsfdcadmdev
61
asked 8 hours ago
sfdcadmdevsfdcadmdev
61
61
New contributor
sfdcadmdev is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
sfdcadmdev is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
I recommend you read up on Date Formats and Date Literals in the SOQL and SOSL Reference. This resource covers several ways you can format date fields that you may find useful in the future. Specifically for your current use case:
Date Literal
LAST_N_DAYS:n
Range
For the number n provided, starts 00:00:00 of the current day and continues for the past n days.
Example
SELECT Id FROM Account WHERE CreatedDate = LAST_N_DAYS:365
answered 8 hours ago
Adrian Larson♦Adrian Larson
112k19125264
add a comment |
please try this
SELECT id, name FROM Account WHERE myDate__c = LAST_N_DAYS:45
answered 8 hours ago
sdandamud1sdandamud1
4027
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "459"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
sfdcadmdev is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsalesforce.stackexchange.com%2fquestions%2f263999%2fhow-to-retrieve-the-correct-account-records-from-soql-query%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
I recommend you read up on Date Formats and Date Literals in the SOQL and SOSL Reference. This resource covers several ways you can format date fields that you may find useful in the future. Specifically for your current use case:
Date Literal
LAST_N_DAYS:n
Range
For the number n provided, starts 00:00:00 of the current day and continues for the past n days.
Example
SELECT Id FROM Account WHERE CreatedDate = LAST_N_DAYS:365
answered 8 hours ago
Adrian Larson♦Adrian Larson
112k19125264
add a comment |
I recommend you read up on Date Formats and Date Literals in the SOQL and SOSL Reference. This resource covers several ways you can format date fields that you may find useful in the future. Specifically for your current use case:
Date Literal
LAST_N_DAYS:n
Range
For the number n provided, starts 00:00:00 of the current day and continues for the past n days.
Example
SELECT Id FROM Account WHERE CreatedDate = LAST_N_DAYS:365
answered 8 hours ago
Adrian Larson♦Adrian Larson
112k19125264
add a comment |
I recommend you read up on Date Formats and Date Literals in the SOQL and SOSL Reference. This resource covers several ways you can format date fields that you may find useful in the future. Specifically for your current use case:
Date Literal
LAST_N_DAYS:n
Range
For the number n provided, starts 00:00:00 of the current day and continues for the past n days.
Example
SELECT Id FROM Account WHERE CreatedDate = LAST_N_DAYS:365
answered 8 hours ago
Adrian Larson♦Adrian Larson
112k19125264
I recommend you read up on Date Formats and Date Literals in the SOQL and SOSL Reference. This resource covers several ways you can format date fields that you may find useful in the future. Specifically for your current use case:
Date Literal
LAST_N_DAYS:n
Range
For the number n provided, starts 00:00:00 of the current day and continues for the past n days.
Example
SELECT Id FROM Account WHERE CreatedDate = LAST_N_DAYS:365
answered 8 hours ago
Adrian Larson♦Adrian Larson
112k19125264
answered 8 hours ago
Adrian Larson♦Adrian Larson
112k19125264
answered 8 hours ago
Adrian Larson♦Adrian Larson
112k19125264
answered 8 hours ago
Adrian Larson♦Adrian Larson
112k19125264
112k19125264
add a comment |
add a comment |
please try this
SELECT id, name FROM Account WHERE myDate__c = LAST_N_DAYS:45
answered 8 hours ago
sdandamud1sdandamud1
4027
add a comment |
please try this
SELECT id, name FROM Account WHERE myDate__c = LAST_N_DAYS:45
answered 8 hours ago
sdandamud1sdandamud1
4027
add a comment |
please try this
SELECT id, name FROM Account WHERE myDate__c = LAST_N_DAYS:45
answered 8 hours ago
sdandamud1sdandamud1
4027
please try this
SELECT id, name FROM Account WHERE myDate__c = LAST_N_DAYS:45
answered 8 hours ago
sdandamud1sdandamud1
4027
answered 8 hours ago
sdandamud1sdandamud1
4027
answered 8 hours ago
sdandamud1sdandamud1
4027
answered 8 hours ago
sdandamud1sdandamud1
4027
4027
add a comment |
add a comment |
sfdcadmdev is a new contributor. Be nice, and check out our Code of Conduct.
sfdcadmdev is a new contributor. Be nice, and check out our Code of Conduct.
sfdcadmdev is a new contributor. Be nice, and check out our Code of Conduct.
sfdcadmdev is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Salesforce Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsalesforce.stackexchange.com%2fquestions%2f263999%2fhow-to-retrieve-the-correct-account-records-from-soql-query%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
