Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
Thank You so much..