Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
kpradeep5610
Contributor III
Contributor III

Two Different selections on a field and find the differences on selected field values

Hi All,

please help me to find out the below problem.

i have a field Which is "DATE_Field" in this if i select any two dates on my interest  it will give the differences between on those selected dates 

Example 

WeekAsOn
24-apr-2020
17-apr-2020
10-apr -2020
31-may-2020
 

 

 

 

Please help me to find it 

 

 

Regards,

Pradeep K.

 

 

 

Labels (1)
2 Replies
Taoufiq_Zarra

I hope this example will help you.

=Date#(Subfield(concat(WeekAsOn,','),',',2),'DD-MMM-YYYY')-Date#(Subfield(concat(WeekAsOn,','),',',1),'DD-MMM-YYYY')

 

Capture.JPG

 

 

Capture.PNG

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
kpradeep5610
Contributor III
Contributor III
Author

Hi Zarra,

Thanks for reply

i'm not getting the differences on two selections, because of here i'm using 3 measures. and please follow the attached png image for reference. and please tell me what is your measures.

 

 

Regards,

Pradeep K.