Tag Archives: Date Functions

SOQL Date functions are pretty useful for grouping or filtering data by date fields. With a proper Date function used in the SOQL, the code can potentially limit the query result records a lot. e.g. Query all Tasks that are created today: The above code looks neat enough although the function DAY_ONLY is not that …

Continue reading “Gotcha: convertTimezone() must be used in SOQL Date functions dealing with Datetime”