날짜 형식
| Format | Format Syntax | Example |
|---|---|---|
| Date only | YYYY-MM-DD | 1999-01-01 |
| Date, time, and time zone offset | YYYY-MM-DDThh:mm:ss+hh:mm YYYY-MM-DDThh:mm:ss-hh:mm YYYY-MM-DDThh:mm:ssZ |
1999-01-01T23:01:01+01:00 1999-01-01T23:01:01-08:00 1999-01-01T23:01:01Z |
SELECT Id
FROM Account
WHERE CreatedDate > 2005-10-08T01:02:03Z
날짜 문자
| Date Literal | Example |
|---|---|
| YESTERDAY | SELECT Id FROM Account WHERE CreatedDate = YESTERDAY |
| TODAY | SELECT Id FROM Account WHERE CreatedDate > TODAY |
| TOMORROW | SELECT Id FROM Opportunity WHERE CloseDate = TOMORROW |
| LAST_WEEK | SELECT Id FROM Account WHERE CreatedDate > LAST_WEEK |
| THIS_WEEK | SELECT Id FROM Account WHERE CreatedDate < THIS_WEEK |
| NEXT_WEEK | SELECT Id FROM Opportunity WHERE CloseDate = NEXT_WEEK |
| LAST_MONTH | SELECT Id FROM Opportunity WHERE CloseDate > LAST_MONTH |
| THIS_MONTH | SELECT Id FROM Account WHERE CreatedDate < THIS_MONTH |
| NEXT_MONTH | SELECT Id FROM Opportunity WHERE CloseDate = NEXT_MONTH |
| LAST_90_DAYS | SELECT Id FROM Account WHERE CreatedDate = LAST_90_DAYS |
| NEXT_90_DAYS | SELECT Id FROM Opportunity WHERE CloseDate > NEXT_90_DAYS |
| LAST_N_DAYS:n | SELECT Id FROM Account WHERE CreatedDate = LAST_N_DAYS:365 |
| NEXT_N_DAYS:n | SELECT Id FROM Opportunity WHERE CloseDate > NEXT_N_DAYS:15 |
| NEXT_N_WEEKS:n | SELECT Id FROM Opportunity WHERE CloseDate > NEXT_N_WEEKS:4 |
| LAST_N_WEEKS:n | SELECT Id FROM Account WHERE CreatedDate = LAST_N_WEEKS:52 |
| NEXT_N_MONTHS:n | SELECT Id FROM Opportunity WHERE CloseDate > NEXT_N_MONTHS:2 |
| LAST_N_MONTHS:n | SELECT Id FROM Account WHERE CreatedDate = LAST_N_MONTHS:12 |
| THIS_QUARTER | SELECT Id FROM Account WHERE CreatedDate = THIS_QUARTER |
| LAST_QUARTER | SELECT Id FROM Account WHERE CreatedDate > LAST_QUARTER |
| NEXT_QUARTER | SELECT Id FROM Account WHERE CreatedDate < NEXT_QUARTER |
| NEXT_N_QUARTERS:n | SELECT Id FROM Account WHERE CreatedDate < NEXT_N_QUARTERS:2 |
| LAST_N_QUARTERS:n | SELECT Id FROM Account WHERE CreatedDate > LAST_N_QUARTERS:2 |
| THIS_YEAR | SELECT Id FROM Opportunity WHERE CloseDate = THIS_YEAR |
| LAST_YEAR | SELECT Id FROM Opportunity WHERE CloseDate > LAST_YEAR |
| NEXT_YEAR | SELECT Id FROM Opportunity WHERE CloseDate < NEXT_YEAR |
| NEXT_N_YEARS:n | SELECT Id FROM Opportunity WHERE CloseDate < NEXT_N_YEARS:5 |
| LAST_N_YEARS:n | SELECT Id FROM Opportunity WHERE CloseDate > LAST_N_YEARS:5 |
| THIS_FISCAL_QUARTER | SELECT Id FROM Account WHERE CreatedDate = THIS_FISCAL_QUARTER |
| LAST_FISCAL_QUARTER | SELECT Id FROM Account WHERE CreatedDate > LAST_FISCAL_QUARTER |
| NEXT_FISCAL_QUARTER | SELECT Id FROM Account WHERE CreatedDate < NEXT_FISCAL_QUARTER |
| NEXT_N_FISCAL_QUARTERS:n | SELECT Id FROM Account WHERE CreatedDate < NEXT_N_FISCAL_QUARTERS:6 |
| LAST_N_FISCAL_QUARTERS:n | SELECT Id FROM Account WHERE CreatedDate > LAST_N_FISCAL_QUARTERS:6 |
| THIS_FISCAL_YEAR | SELECT Id FROM Opportunity WHERE CloseDate = THIS_FISCAL_YEAR |
| LAST_FISCAL_YEAR | SELECT Id FROM Opportunity WHERE CloseDate > LAST_FISCAL_YEAR |
| NEXT_FISCAL_YEAR | SELECT Id FROM Opportunity WHERE CloseDate < NEXT_FISCAL_YEAR |
| NEXT_N_FISCAL_YEARS:n | SELECT Id FROM Opportunity WHERE CloseDate < NEXT_N_FISCAL_YEARS:3 |
| LAST_N_FISCAL_YEARS:n | SELECT Id FROM Opportunity WHERE CloseDate > LAST_N_FISCAL_YEARS:3 |