Latest Contributions by KhemAryal

I am struggling with Power Automate Survey123 create report to get the results only for the previous month. As it can be done easy for the last x days but I want for the last month.  I tried different SQL syntax in 'Where' clause. I can do for last 30 days or any number of days but not all the months are 30 days. There should be an easy way to do it but I kept failing. any suggestion? BETWEEN CURRENT_TIMESTAMP - 30 AND CURRENT_TIMESTAMP successfully creates a report with results for the last 30 days. But I need to create report for previous month automatically to create a report every month. Thank you in advance ... View more

After upgrading to ArcGIS pro 3.0.2, I don't see the utility solutions for CCTV Manager. The geoprocessing tool should have contained 'Import Access Table' and 'Generate Pipe Features' tools. Any Idea? ... View more

I have a map displaying over 4000 features, each with unique IDs. Out of these 4000 features, I need to display only 250 features with selected unique IDs. Is there a short  formula to display only those 250 features.  List of features id : 1964004 1444000 1719002 1452034 1618000 1602002 2004000 1175000 2012000 1172002 1946000 continues to 250 ids   Expression I used: var mh = $feature.UNITID; if ((mh=="1964004")||(mh=="1444000")||(mh=="1719002")||(mh=="1452034")||(mh=="1618000")||(mh=="1602002")||(mh=="2004000")||(mh=="1175000")||(mh=="2012000")||(mh=="1172002")||(mh=="1946000")){ return"selected"; } else { return""; } This works as intended but I am wondering if there is a short expression where I can just copy the list rather than typing each features in the bracket Thanks KA ... View more