Comments
-
Thanks Also, I thought it was the best way to go. I solved with this sql. It needs to be filtered with the right year as well . SELECT * from all_members_data_raw WHERE (EXTRACT(MONTH from `Member Start Date`) = EXTRACT(MONTH FROM DATE_SUB(now(),INTERVAL 1 MONTH)) AND EXTRACT(YEAR from `Member Start Date`) = EXTRACT(YEAR…
-
Thanks Darious, I just was wondering if it was possible to extract in json format. Text/CSV will do the trick for now. Cheers, Jose