SysQueryRangeUtil - with Time function ?

(0) Share

Report

Posted on by Community Member

Hi,

just a general question is it possible for us to add a time function to say (dayrange(30,0)) as we would like to pull back all data from a previous date Upto todays current time -1 hour.

Thanks in advance

Jordan

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Martin Dráb 239,660 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Yes, you can add your own methods to SysQueryRangeUtil.

When writing it, don't forget that datetime values in database are in UTC, not in your local time.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi,

Thanks for that information, However upon selecting the query inside the Sales ledger can you display an example if i wanted to return the previous 30 days along with current date then a certain hour ?

i understand the first part would be (dayrange(30,0))

Was this reply helpful? Yes No
Martin Dráb 239,660 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

No, there won't be two parts. You need a single function working with utcDateTime values.

Was this reply helpful? Yes No