SQL Import statements

3 posts 0 new
Log in or register to post comments.

SQL Import statements

Good day,

I would like to import data using SQL import. The data will be imported automatically once a month. However I want to import data for a particlar period each month so that I get values for a particular period. Below is my SQL statement but it import total values for a given year which means the data will accumulate each period.

SELECT  SUM("       Open Items")/SUM("       Outstandin")*100  as ArrearsFROM [loans Ageing Report$]WHERE  DateSerial(Year(format(Replace("Term Start",'.','-'),'dd/mm/yyyy')),Month(format(Replace("Term Start",'.','-'),'dd/mm/yyyy')),Day(format(Replace("Term Start",'.','-'),'dd/mm/yyyy')))  BETWEEN #2018-04-01# AND #2019-03-31# AND "Term Start" IS NOT NULL  

I do not want to manually edit the statment every month to change the dates. If 60 business were created in May, I want to put 60 and not the total businesses created for the year.

PLEASE ASSIST

Hi,

Please contact QPR CustomerCare at customercare@qpr.com, we need further information on what you are trying to accomplish.

- Janne, QPR CustomerCare

Hi,

Please contact QPR CustomerCare at customercare@qpr.com, we need further information on what you are trying to accomplish.

- Janne, QPR CustomerCare