I posted the following to Google Sheets Community for help; however, my post was removed for violating "Community Policy." I can't figure out what policy I violated, and there doesn't seem to be a way to ask. So I am requesting help here.
I am using
=query(IMPORTHTML("https://www.cnbc.com/quotes/?symbol=cp&qsearchterm=&cp", "table", 1))
to import Earnings Date (under Events) from CNBC.
I need help configuring the last part of the formula (the part after "table"). I only need to import the date.
Thank you.
Any help I can get from this forum will be greatly appreciated.