Arcade Data Expression

Question

Hi All,

I want to get the current time data using Data Expression.

In my feature layer having the data of (future as well as historic) current time and for the next two days on hourly basis i.e. 2:30 PM, 3:30 PM, I want to get the data which is related to current hour is running.

Let's suppose now time is 6:40AM. only push the feature which is coming under that time.

Regards,

Sunita

JakeSkinner · Answer

@Kristofer ,

Try the following:

var year = Year(Now());
var month = Month(Now());
var day = Day(Now()) + 1;
var hour1 = 00;
var minute1 = 00;
var second1 = 00;
var hour2 = 23;
var minute2 = 59;
var second2 = 59;
var dateField = $feature.duedate;

var tomorrowDate1 = Date(year, month, day, hour1, minute1, second1)
var tomorrowDate2 = Date(year, month, day, hour2, minute2, second2)

IIf(dateField > tomorrowDate1 && dateField < tomorrowDate2, 'future', 'past');

Kristofer · Answer

Hi @JakeSkinner

I wanted to Data expression code but you have shared the documentation for pop-up.

Thanks for the response.

Kristofer · Answer

Hi @JakeSkinner

I want to filter the data only for tomorrow from 12:00 am to 11:59 pm. I tried to using json editor also.

time BETWEEN timestamp(CURRENT_DATE (), +1, 'day') AND timestamp(CURRENT_DATE (), +1, 'day')

also wanted to another filter the data from tomorrow day after.

Could you please help me on this.

Regards,

Sunita