-
The date in excel, show different with saved search
On the saved search, the date show 14/8/2026. Then I click the export excel button and open the file it shows 13/8/2026. However I export CSV and open the file, it shows 14/8/2026. It seem like happen after upgrade by the system. So what should I resolve it.
-
Saved Search Date Formula - Two Months
Hello, We have a saved search that pulls scheduled appointments and runs every Monday. We we want to limit the results to two months worth of upcoming data, but i cant figure out the date formula. For example, if the search ran on 11/10/25, we want to see appointments for 11/10/25-1/10/26. When the search runs next Monday…
-
How to choose a custom relative date in a workbook?
Hi, I was wondering if you could choose a custom relative date criteria in a workbook. I know you can do this in a saved search. I was wondering if there was an equivalent functionality in a workbook. I couldn't find it. I wanted to ask to see if I was missing something or if it is just not possible. Here is a screen shot…
-
Reconcile Account Statement Date Error
Hi Gurus, We're trying to reconcile our bank accounts for August. When we try to change the date to 8/31/24, we receive the error 'You cannot enter a date earlier than the close date for the last reconciled statement. Enter a new date.' Our last reconciliation is dated for 7/31/24, so we should not be encountering this…
-
SuiteQL: date field "is not on or before three days ago"
I have a saved search that uses the above as a criteria. How can I do that in a SuiteQL query ? In general I need to be able to specify date ranges relative to the current date. Thanks in advance !
-
Date/Time Math in SuiteQL
Hello, I am extracting data via SuiteQL using the Suiteanalytics Connect ODBC driver. Some of the use cases include various date and datetime output columns as well as date and datetime predicates. This article by Tim Dietrich implies that we can simply add a fractional day to a DATE datatype.…
-
All Sales Invoice transactions appear in Belgian VAT Report, despite the defined date range
All Sales Invoice transactions appear in Belgian VAT Report, even though they are not from the period defined in the header of the report page. Could someone please help me solve this? Thanks!
-
Workflow - Set Field Value - Convert time/date field to date field
Hi, I have a workflow where I'm trying to Set a custom Date field with the value from the Date Created field. If I do the following: It will pull the date created, but use the current year instead of the year the record was created: My guess is this is happening because the field I'm trying to set the value to is a DATE…
-
Saved Search Date Formula - Records One Week Old
Hello, We have a saved search where we would like to exclude records that are more than 1 week older/past the Date field. Im having trouble with the date formula Any help is appreciated.
-
Saved Search Criteria Most Recent Date
Hi, I am trying to build a KPI that calculates the total value of product on hand for a given vendor. To do this I thought I would do an item saved search. I was thinking pull all items that exist on a purchase order for the given vendor. From there I can grab on hand quantity and rate to get a total value. However, in…