Announcements
Meet our latest featured member Bruno! Drop a like and comment. READ ON
cancel
Showing results for
Did you mean:
Specialist

## 2 Calendar object in one selection

hi all,

in my model i use calendar object to select date range dynamically,

i want to enhance that and compare values between different dates

Date_A and Date_B are originally Date field loaded with alias to use two Calendar object.

all is working well separately but when selecting both, first selection drops off the current selection..

i use below expressions in the table but only one can work at the time..

any ideas?

sum({\$<Date_A =>}Amount)

sum({\$<Date_B =>}Amount)

1 Solution

Accepted Solutions

I would ask you to write something like below

Sum({<Date_A = {">=\$(Period_A_From) <=\$(Period_A_To)"}, Date_B = {">=\$(Period_B_From) <= \$(Period_B_To)"}>} Amount)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
3 Replies

I would ask you to write something like below

Sum({<Date_A = {">=\$(Period_A_From) <=\$(Period_A_To)"}, Date_B = {">=\$(Period_B_From) <= \$(Period_B_To)"}>} Amount)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Specialist
Author

hi Anil, thanks for your swift replay.

solved it with below expressions

period a

Sum({\$<date_a={"<=\$(vEndDate)>=\$(vStartDate)"}>}amount)

period b

Sum({\$<date_b={"<=\$(vRangeEnd)>=\$(vRangeStart)"}>}amount)

again thank you

This make sense and i would ask you to write like below for next KT person

period a

Sum({\$<date_a={">=\$(vStartDate)<=\$(vEndDate)"}>}amount)

period b

Sum({\$<date_b={">=\$(vRangeStart)<=\$(vRangeEnd)"}>}amount)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Community Browser