Mfcttrf

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;

1

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

share|improve this question

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 | 

1

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

share|improve this question

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

share|improve this question

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.

SELECT id, name 
FROM Account 
WHERE myDate__c <= today() - 45

share|improve this question

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.

share|improve this question

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

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

2 Answers
2

active

oldest

votes

4

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

share|improve this answer

answered 8 hours ago

Adrian Larson♦Adrian Larson

112k19125264

add a comment | 

-1

please try this

SELECT id, name FROM Account WHERE myDate__c = LAST_N_DAYS:45 

share|improve this answer

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.

draft saved

draft discarded

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

Name

Email

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

Name

Email

Required, but never shown

4

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

share|improve this answer

answered 8 hours ago

Adrian Larson♦Adrian Larson

112k19125264

add a comment | 

4

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

share|improve this answer

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

share|improve this answer

answered 8 hours ago

Adrian Larson♦Adrian Larson

112k19125264

share|improve this answer

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

-1

please try this

SELECT id, name FROM Account WHERE myDate__c = LAST_N_DAYS:45 

share|improve this answer

answered 8 hours ago

sdandamud1sdandamud1

4027

add a comment | 

-1

please try this

SELECT id, name FROM Account WHERE myDate__c = LAST_N_DAYS:45 

share|improve this answer

answered 8 hours ago

sdandamud1sdandamud1

4027

add a comment | 

please try this

SELECT id, name FROM Account WHERE myDate__c = LAST_N_DAYS:45 

share|improve this answer

answered 8 hours ago

sdandamud1sdandamud1

4027

SELECT id, name FROM Account WHERE myDate__c = LAST_N_DAYS:45 

share|improve this answer

answered 8 hours ago

sdandamud1sdandamud1

4027

answered 8 hours ago

sdandamud1sdandamud1

4027

answered 8 hours ago

sdandamud1sdandamud1

4027