Solved

Google Sheet connector and date format

  • 4 December 2023
  • 3 replies
  • 110 views
Dave L
Rank
Userlevel 1
Badge +2
  • Dave L Newly Minted Pigmenteer
  • 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

Dave L
Rank
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! 

MKohli
Rank
Userlevel 4
Badge +8

@Justin Groover Are you able to share the workaround?

J
Rank
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


Ask your question here!

Terms & ConditionsCookie settings