regarding expression

[Dnyanesh5559]

Col1_date in between [col2 _date<=15 and col2_date>=1]

I want col1_date between col2_date<=15 and col2_date>=1 this range
Please provide some logic to build.
I am doing this on front side.

if(num#(date(key_date,'DD'))<=15 and  num#(date(key_date,'DD'))>=1,date(NETDUEDATE,'DD-MM-YYYY'),'NULL')

I am trying this one but its showing error

[rubenmarin]

Hi, if key_date is a date you can use:

If(Day(key_date)>=1 and Day(key_date)<=15, date(NETDUEDATE,'DD-MM-YYYY'),Null())

Or: Aggr(If(Day(key_date)>=1 and Day(key_date)<=15, date(NETDUEDATE,'DD-MM-YYYY'),Null()),key_date)

[Dnyanesh5559]

Thank You so much..