Lookup Objects, trying to derive dates happening Today

[Ste404]

Hi all,

I have a scheduled automation that runs at 3am.  I would like to return all the items from Assets that have a date from a particular field that will happen on the day the scheduled automation runs.

I need to set a value for 'Inspection' in Assets to True if the 'Inspection Date' for an item is on the day the automation runs.

I just can't put the lookupObjects query together to come up with the narrow on this day information to be returned.  I can't use startofDay() or endofDay() it seems also in the query, so not sure how to wrangle this.

[Ste404 · Accepted solution]

leveraged the above as a start date variable and added this for the end date variable

.plusDays(1)

I have my start and end period for the current day as variables.

[Ste404 · Accepted solution]

ok I can come up with the start of the day

{{now.toDateTimeAtStartOfDay("Australia/Sydney").shortDateTime}}

I can't see how to do the same for the end of the day