Question

Excel connector and date format

  • 6 June 2024
  • 1 reply
  • 30 views

Badge

Hello Pigment community,

I am trying to use the excel connector for Pigment and I have realized that when pulling the data the dates are formatted as text. When I change the format to date and I pull the data again it reverts to the text format.

Is there a solution to this limitation?

 

Thank you in advance,

Gabriel Ortiz


1 reply

Userlevel 2
Badge +7

Hi @Gabriel Ortiz ,

It’s necessary to convert the data format in Pigment instead of in Excel.

  1. If the block you want to pull to Excel is a Metric, you need to make sure its data type is Date
  2. If the block is a Transaction list or a Dimension, you can check if the date column type is Date

Regards,

Weining

Reply