Skip to main content
Solved

Converting date column to month dimension

  • 5 April 2023
  • 3 replies
  • 442 views

 

3 replies

Mat
Rank
Userlevel 3
Badge +5

Hi @Hamza, thanks for your question!

If I’ve understood your post correctly, you will need to use the following function in your formula definition on the property that will hold the month. Try the following format:

TIMEDIM(BlockName.Property, Month)

If your Month dimension exists in another application, I’d advise using the autocomplete dropdown to make sure you’re properly referencing that dimension.

Hope this helps!

Mat | Pigment Specialist
Keiran
Rank
Userlevel 5
Badge +8

Hi Hamza,

 

I’ve used some sample data I have for an example here, in the Transaction List I create a Property with the Dimension Month

 

I then select this dimension to add a formula

 

I then use the TIMEDIM function | Community (gopigment.com) to write the formula

TIMEDIM(Ticket_Data.'Raised Date',Month)

 

This gives me the correct dimension.

 

Hopefully this helps! :)

Keiran | Pigment Specialist (Support Team Lead)
H
Rank
Userlevel 1
Badge

Thank you Mat and keiran, thank you guys it was clear and very heplful 

Reply


Ask your question here!

Terms & ConditionsCookie settings