topic regarding expression in App Development

regarding expression

Dnyanesh5559 — Thu, 22 Sep 2022 09:04:28 GMT

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

Re: regarding expression

rubenmarin — Thu, 22 Sep 2022 10:08:40 GMT

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)

Re: regarding expression

Dnyanesh5559 — Thu, 22 Sep 2022 10:25:38 GMT

Thank You so much..