Ask a Question

SOQL date comparison for formula(date) date type

in Education by
can anybody help me with writing a SOQL query. Using "Date" data type in WHERE statement is easy, it behaves like a normal Date would. But if the data type is "Formula(Date)" it seems like normal date time functions are not working. In sample query like SELECT Date_of_purchase__c FROM Goods WHERE Date_of_purchase__c = 2011-11-04 all works fine if "Date_of_purchase__c" field is "Date" type. But the same query fails if the field type is "Formula(Date)". What am I doing wrong? Thanks! JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

1 Answer

0 votes
by
Are you 100% sure your formula is using the date type and not datetime? I just created a formula field on Contact to test, using the formula: DATEVALUE(CreatedDate) I then ran the following code in the system log: System.Debug([Select Name From Contact Where CreatedDateF__c = 2011-12-16]); and I can see that it returned 20 rows.

Related questions

0 votes
Q: SOQL query WHERE Date = 30_days_ago?
    How do I make a SOQL query like this? SELECT id FROM Account WHERE LastActivityDate = 30_DAYS_AGO This produces an ... = 30_DAYS_AGO ^ Select the correct answer from above options...
asked Feb 2, 2022 in Education by JackTerrance
0 votes
Q: date comparison in oracle for the year ends with 00
    The date stored in my database is 01-01-1900 for field emp_doj(Data Type DATE). But while retrieving ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Feb 19, 2022 in Education by JackTerrance
0 votes
Q: Explain the types of SOQL statements in Salesforce.
    Explain the types of SOQL statements in Salesforce....
asked Jun 26, 2021 in Technology by JackTerrance
0 votes
Q: What is the difference between SOQL and SOSL in Salesforce?
    What is the difference between SOQL and SOSL in Salesforce?...
asked Nov 11, 2020 in Technology by JackTerrance
0 votes
Q: To make pointer generic for which date type it need to be declared?
    To make pointer generic for which date type it need to be declared?...
asked Nov 9, 2020 in Technology by JackTerrance
0 votes
Q: Diff/comparison tools for TFS/VS [closed]
    As it currently stands, this question is not a good fit for our Q&A format. We expect answers to ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Feb 24, 2022 in Education by JackTerrance
0 votes
Q: The algorithm that uses a secondary ordered index to guide retrieval for comparison conditions involving <,≤,≥, or > is
    The algorithm that uses a secondary ordered index to guide retrieval for comparison conditions involving is ( ... Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: 4. Date and Time are supported as Data Type in Calc.
    4. Date and Time are supported as Data Type in Calc. 5. When using functions and formulas in LibreOffice Calo, it ... and send me fast Select the correct answer from above options...
asked Dec 17, 2021 in Education by JackTerrance
0 votes
Q: Redundant comparison & "if" before assignment
    Here is the example: if(value != ageValue) { ageValue = value; } I mean, if we assign the value ... , JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 24, 2022 in Education by JackTerrance
0 votes
Q: Time Complexity of String Comparison
    I ran some test to determine if O(==) for Strings is O(len(string)) or O(1). My tests: ... questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 9, 2022 in Education by JackTerrance
0 votes
Q: Object comparison in JavaScript [duplicate]
    This question already has answers here: How to determine equality for two JavaScript objects? (78 answers) ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 9, 2022 in Education by JackTerrance
0 votes
Q: Null or default comparison of generic argument in C#
    I have a generic method defined like this: public void MyMethod(T myArgument) The first thing I want to ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 24, 2022 in Education by JackTerrance
0 votes
Q: Null or default comparison of generic argument in C#
    I have a generic method defined like this: public void MyMethod(T myArgument) The first thing I want to ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 24, 2022 in Education by JackTerrance
0 votes
Q: Null or default comparison of generic argument in C#
    I have a generic method defined like this: public void MyMethod(T myArgument) The first thing I want to ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 24, 2022 in Education by JackTerrance
0 votes
Q: Null or default comparison of generic argument in C#
    I have a generic method defined like this: public void MyMethod(T myArgument) The first thing I want to ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 24, 2022 in Education by JackTerrance

© Copyright 2018-2023 www.Blogmepost.com. All rights reserved. Developed by Blogmepost.

...