soql query based on closedate code example
Example 1: soql last week
Select * from case where WHERE CreatedDate = LAST_N_DAYS:30
Example 2: string literal soql date format
//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