Answered

Search query using addHours in an expression not resulting in correct results in GetEmails v3

(0) Share

Report

Posted on by tcs5t

I am using GetEmails v3 to look for emails with certain subjects, senders, etc to file them after they are nn hours old.

To determine the receipt time, I'm using this Search Query:

where the expression is: formatDateTime(addHours(utcNow(),-1),'yyyy-MM-ddThh:mm:ss') - to identify messages over an hour old.

Messages are identified and moved based on this expression, but it seems to only affect messages prior to today. Even if I change addHours to addMinutes and use -60 minutes, it appears to only affect messages received prior to today.

Any suggestions?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report

Hi @tcs5t,

In your Search query in the screenshot I see your condition is reveived date time needs to be less than or equal to yesterday.

Can you switch your operator to the greater than sign to see if that makes a difference? (received >= )

Was this reply helpful? Yes No
tcs5t 9 on at

Like (0)

Report

Thanks @Expiscornovus, I did try that. It had the effect of finding all messages matching the query, received since an hour ago.
So my test results are this:
received<= [fx formatDateTime(addHours(utcNow(),-1),'yyyy-MM-ddThh:mm:ss')] finds everything yesterday and earlier.
received>= [fx formatDateTime(addHours(utcNow(),-1),'yyyy-MM-ddThh:mm:ss')] finds everything an hour ago and later.

Goal: Find everything an hour ago and earlier. I'm not sure why the first query results only in finding items received the yesterday.

Thanks for the reply - I really appreciate it.

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,195 Most Valuable Professional on at

Like (1)

Report
Hi @tcs5t,

I did not notice before in your first post. But you are using lower case hh for hours format (12 hour clock).

Try HH, this will be 24 hour format.

formatDateTime(addHours(utcNow(),-1),'yyyy-MM-ddTHH:mm:ss')

With your current format it will probably be an hour very early in the morning. Which probably is the reason why it is retrieving e-mails from yesterday 😉

Was this reply helpful? Yes No
tcs5t 9 on at

Like (1)

Report

@Expiscornovus, That's it!! Thank you so much. That was the solution.

Was this reply helpful? Yes No