(1)-a. DateTime Selection

Owned by Site_admin_1
Last updated: 12月 26, 2024 by skyvisualeditor_developer

Field name

Detail

Criteria setting

Set Date or DateTime




Date

Select from calendar or input directly in field

Input with yyyy-MM-dd format

Time

Select or Input Time

Input with HH:mm format

TimeZone

Select time zone

Literal Setting

Set literal value of Date field to select as search condition prepared by Salesforce



Literal

Select from the list below

LAST n DAYSYESTERDAYTODAYTOMORROWNEXT n DAYS
LAST n WEEKSLAST WEEKTHIS WEEKNEXT WEEKNEXT n WEEKS
LAST n MONTHSLAST MONTHTHIS MONTHNEXT MONTHNEXT n MONTHS
LAST n YEARSLAST YEARTHIS YEARNEXT YEARNEXT n YEARS
LAST n QUARTERSLAST QUARTERTHIS QUARTERNEXT QUARTERNEXT n QUARTERS

Period

If “n” is included in [Literal], set value in “n”

Please refer to< https://developer.salesforce.com/docs/atlas.en-us.226.0.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_dateformats.htm > for more details on Date Formats and Date Literals.