How to subtract month in lookml

Can we subtract months form ${created_date} in lookml. 

Eg: ${created_date} - 13 Months

which should give me the last 13 month data

0 1 486
1 REPLY 1

JMJ1
Participant II

Depends on the database, in bigquery you could do it this way :

sql: DATE_ADD(${created_date}, INTERVAL -13 MONTH)  ;;
 

Top Labels in this Space
Top Solution Authors