Using the Calendar in PocketQuery with a SQL returned dataset is not working

[Craig Day]

I'm trying to use the Google Calendar gadget in PocketQuery. I'm not entirely sure my dataset is returning the proper date datetime format. But I am unable to get it to work regardless of what I do.

I tried to "prep" the query result in the template before calling the PocketQuery.chart('Calendar'); function but I keep getting "Invalid data table format: column #0 must be of type 'date|datetime'. But I can't figure out what this format really is. 

My formatted $result looks like this:

{ltb='2017-02-09', id=8123},

.....

I use the 'Table' chart as well and the rendered result looks like

1486627200000

8,123

Any ideas?

[Felix Grund (Scandio) · Accepted solution]

Hi Nick,

Thank you for your interest in PocketQuery! Please first check out this post: https://answers.atlassian.com/questions/39138318. I think the issue is quite the same.

Best, Felix (Scandio)

[Craig Day]

Hi Felix,

Thanks! I was actually able to get it to work after some tinkering and my implementation ended up looking very similar to the one in your link.