Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can anyone convert this expression in Set Analysis -
Count(DISTINCT If((DOL1='01/01/1900' or DOJ >= Date(Today(),'DD/MM/YYYY')),Code))
Thanks
Try Below Expression:
Count( distinct { <DOL1={'01/01/1900'}>+<DOJ = { '>=$(=Date(Today(),'DD/MM/YYYY'))'} >} Code)
**please check date formats
Hi Sasi,
By using this expression, one part is working that is {'01/01/1900'} but after OR part is not working. Data is missing.
DOJ = { '>=$(=Date(Today(),'DD/MM/YYYY'))'
is not working.
You can check with attached xls.
Thanks.
HI try below one
Count( distinct { <DOL1={'01/01/1900'}>+<DOJ = { ">=$(=Date(Today(),'DD/MM/YYYY'))"} >} Code)