python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - jsforce

<Today_date>T00:00:00.000+0000 is not returned when TODAY is used in Where clause

I am inserting record with scan_date as <Today_date>T00:00:00.000+0000, but I am not able retrieve the same using scan_date = TODAY (SOQL). example: There is record with scan_date = "2022-0...
test-img

Suvel Rathneswar

node.js

soql

jsforce

Votes: 0

Answers: 1

Latest Answer

I solved using DAY_ONLY() I used the DAY_ONLY() with Scan_Date__c to just compare the date and ignore the time. SELECT Id FROM <Table_name> where DAY_ONLY(Scan_Date__c)=TODAY Reference https:...
test-img

Suvel Rathneswar

Posts

Questions

Blogs

Jobs