Query with DateTime field in Salesforce
If you have to work with DateTime field in Salesforce, consider next items:
1. Don't use quote
For example:
SELECT Id FROM Opportunity WHERE CreatedDate > 2005-10-08
2. Use DateTime literals: YESTERDAY, TODAY, TOMORROW, LAST_WEEK, THIS_WEEK, NEXT_WEEK, ...
For example:
SELECT Id FROM Account WHERE CreatedDate = LAST_WEEK
3. DateTime in Salesforce is UTC format
For example(C#):
string strSQL = "SELECT Id FROM Opportunity WHERE CreatedDate > " + DateTime.Today.ToString("yyyy-MM-dd");
Wednesday, November 16, 2011
Subscribe to:
Post Comments (Atom)
-
Resources: [1] Hela https://ome.grc.nia.nih.gov/iicbu2008/hela/index.html
-
mas plugins http://devsnippets.com/reviews/using-jquery-to-style-design-elements-20-impressive-plugins.html http://www.extjs.com/deploy/dev/...
-
Episodios: Épisode 1 : La Libertina de calidad (Le Libertin de qualité) Épisode 2 : La Apuesta de las tres cotillas (La Gageure des tr...
Vitamina D - Cancer
[1] https://ensedeciencia.com/2023/10/14/la-potente-vitamina-que-protege-frente-al-cancer-de-prostata-y-otros-tipos-de-cancer/
No comments:
Post a Comment