Solved

Extract Day from a date in text format

  • 18 June 2024
  • 3 replies
  • 48 views
M
Rank
Userlevel 1
Badge
  • Mohan Newly Minted Pigmenteer
  • Newly Minted Pigmenteer
  • 3 replies

Hello,

I have a Date field called “Delivery Date” (Ex : 10/06/2024). From here, I want to extract the day of the week in text format (Example :10/06/2024 is “Monday”) and my calculated field should show similar to the example here. I tried WEEKDAY(‘Delivery Date’) and it returns day of the week but in number format and I tried again TEXT(WEEKDAY(‘Delivery date”), again it does not work. How to convert weekday into Text format like Mon,Tue,etc…?

 

thanks

Mohan

icon

Best answer by Weining Ben 18 June 2024, 12:32

View original

3 replies

Issam Moalla
Rank
Userlevel 5
Badge +9

Hi @Mohan ,

A possible solution is to refer to the name property in “Day of Week” Dimension.

 Your formula would be:

ITEM(Weekday('Delivery date'),'Day of Week'.Id).Name


Where ITEM will search for the Day of week item based on the unique property ID.
 

Hope this helps,
Issam

W
Userlevel 2
Badge +7

Hello Mohan,

Firstly, you can create a Weekday dimension.

Then, assuming your Delivery Date column is in a transaction list, so you can achieve your needs by referencing the Weekdays dimension:

Hope my answers helps.
Weining

M
Rank
Userlevel 1
Badge

Thanks for the solution. I will go with the reference dimension method

Reply


Ask your question here!

Terms & ConditionsCookie settings