์ฆ๊ฒจ์ฐพ๊ธฐHema Sundara Ganta ๋์ด #Integration์ ์ง๋ฌธํ์ต๋๋ค2020๋ 8์ 24์ผ ์คํ 12:14Looking for DATEDIFF equivalent in SOQLHello, I am looking for emails that were stale for past 4 hours. In SQL DATEDIFF works perfectly, but in SOQL, I am trying to find a proper solution๋ต๋ณ 3๊ฐ์ ๋ ฌ๋ ์ง๋ณ ์ ๋ ฌ๊ฐ์ฅ ์ ์ฉํ ํญ๋ชฉ๋ณ ์ ๋ ฌ๋ ์ง๋ณ ์ ๋ ฌ๋๊ธ ๋ ๋ณด๊ธฐ...Hema Sundara Ganta2020๋ 8์ 24์ผ ์คํ 3:54Hi Vinay,Thanks for the quick reply. However, I am looking for something similar to Datediff(hh,emaildate,getdate()) = 4 in SQL. Is this possible in SOQL?๋๊ธ ์ถ๊ฐ๋ต๋ณ์ ์์ฑํ์ธ์...๊ตต์ ๊ธ๊ผด๊ธฐ์ธ์ธ ๊ธ๊ผด๋ฐ์ค์ทจ์์ ๋ถ๋ฆฟ ๊ธฐํธ ๋ชฉ๋ก๋ฒํธ๊ฐ ์ง์ ๋ ๋ชฉ๋ก๋งํฌ ์ถ๊ฐ์ฝ๋ ๋ธ๋ก์ด๋ฏธ์ง ์ฝ์ ํ์ผ ์ฒจ๋ถ๋งํฌ URL์ทจ์์ ์ฅ0/9000๋ต๊ธ ์ฐ๊ธฐ
Hema Sundara Ganta2020๋ 8์ 24์ผ ์คํ 3:54Hi Vinay,Thanks for the quick reply. However, I am looking for something similar to Datediff(hh,emaildate,getdate()) = 4 in SQL. Is this possible in SOQL?
