Solved

How create current date matric, which fetch current date automatically?

  • 22 July 2022
  • 8 replies
  • 332 views

Userlevel 4
Badge +6

I want same feature like Today() in Excel.

icon

Best answer by Chris 1 September 2022, 23:19

View original

8 replies

Userlevel 2
Badge +1

Hi  abhilashsawla I have the same question, did you found a way replicate TODAY() formula in Pigment?

 

Userlevel 4
Badge +6

I did not find. 

if you find the solution for the same, please let me know.

Hi @abhilashsawla @Jose 

Can you tell us a bit more about your use cases and what you are trying to achieve? Depending on your situations, there may be a few solutions to this, and it may be a new feature our product team is working on. 

Looking forward to your response.

Badge

Hello, 

I was looking to achieve something similar. I was trying to use todays date to determine if a Project is active. The project has a start and end date. I was also trying to use the INPERIOD function but couldn't quite figure if that worked for this. Essentially in Excel it’s an IF statement TRUE/FALSE if todays date falls with in the project start and end date to determine if its active. 

 

Active?:  IF(AND(TODAY()>Start Date, TODAY()< End Date), TRUE, FALSE)

Userlevel 7
Badge +13

Hi @jbellcourt     
We don’t currently have a today() function but its definitely on our radar.   
You could use the prorata function.       

Your formula would look something like this.   if(prorata(Month,Project.'start Date',Project.'end Date'+1)=1,true,false)

 

Let me know if that helps. 

Badge +2

Hi @Tess.Hunt a current date or current year function would be really helpful.
It is usefull for a lot of cases. Currently I would like to dynamicaly filter the displayed years on a metric view and not maintain it year over year.
Regards, David

Hi @David Mandl . Thanks for your response. As Chris mentioned, it’s definitely on our radar and the use cases everyone has provided here has been fed back to our product team :)

Userlevel 3
Badge +2

Hi @Tess.Hunt any update on this feature, will this feature be available on pigment soon?

Reply