Date issues with our current date semantic

[asirota]

For now I am testing this in Invoices to show the issues I am having. I am using this link

https://datastudio.google.com/s/taqiAtScODE

(page 5).
The invoice created date should be a normal data type that you can reformat using the built in date formatting features. Unfortunately this does not work so we have to resort to todate functions to get the date to format the way we want. This is very important for grouping by month to do aggregations on invoices for example.

Setting the granularity should convert to a different level of date granularity but we get nulls instead.

I have to resort to using todate() to grab the necessary date components and reformatting them in various means.

or this to concatenate month and day

This is not ideal nor user-friendly. It appears the underlying data format from WA is either nonstandard or we are not setting the date semantic/format correctly to let GDS treat our date properly.

[asirota]

The workaround for now is to use the TODATE() function to cast into the correct format you want for

the date:

[miasmos]

The dates were never being properly parsed, so in the reports they were just strings, not dates.

[asirota]

Ok here are the fields that are still not properly working with setting type/granularity
Contacts

• Level last changed
• Member since
• Renewal due

[asirota]

Merged into 2.1 release