Need help. Flow works fine but want to put in a condition for only records created in last hour (or whatever). Can do minus days easily enough.
But applying same for hours doesn't work...e.g. AddHours(utcNow(),-1). Presuming because of formats?
<CreatedOn> field is format yyyy-mm-dd hh:mm:ss.ttt
Thanks, I used addHours(formatDateTime(utcNow(), 'yyyy-MM-dd HH:mm:ss'),-1) but that worked too. Seems formatting helps to identify as a time....
Hi @KevRichards,
Could you please try to format as below:
addhours(utcNow('yyyy-MM-dd hh:mm:ss.ttt'),-1)