Solved

Google Sheet connector and date format

  • 4 December 2023
  • 3 replies
  • 103 views

Userlevel 1
Badge +2
  • Newly Minted Pigmenteer
  • 5 replies

We are pulling data from a view in Pigment into Sheets via the Pigment Connector and have noticed that the date information that is pulled does not necessarily reflect correctly.

The month in Pigment, for instance, shows “Jan 24”.  However, when this data is pulled into Sheets via the connector, the actual underlying date comes over as 1/24/2023 (which would be January 2023, and not January 2024).  Is there a known way to account for this disconnect in dates between the month in Pigment and the way that gets translated into Sheets?  Below are a few screenshots to illustrate the point:  

January 2024 date in Pigment translates to January 2023 in Sheets via the connector
January 2024 date in Pigment translates to January 2023 in Sheets via the connector

 

icon

Best answer by Dave L 4 December 2023, 21:31

View original

3 replies

Userlevel 1
Badge +2

We have found a workaround to update the header label in Pigment to something more easily translated in Gsheets/Excel for the proper dates.  Big thanks to @Justin Groover for the assist! 

Userlevel 4
Badge +8

@Justin Groover Are you able to share the workaround?

Userlevel 2
Badge +4

@MKohli We just created a text property on the month dimension to return a text value of the month’s end date, then use that property as the header label for the month dimension in the view being pulled to G sheets.  I imagine there are different ways to write the formula to return desired output (e.g., make it return “Dec 31, 2023”) 

 

Reply