Filter by date in script

[#1]

Hi,

I need to load a excel file via load script, by filtering by a date field, i.e. Fecha > "01-05-2014 00:00:00".

I don't know how filter data neither how manage this date format

Any help?

Thanks in advance

[ashfaq_haseeb · Accepted solution]

Hi

You may try

load *

From <excel fie>

where Fecha > 01-05-2014 00:00:00

If possible try to post your sample here. to get faster reply.

Regards

ASHFAQ

[Anonymous]

Date "likes" to be in the single quotes:

where Fecha > '01-05-2014 00:00:00'

[#4]

Thanks a lot!!!

[#5]

Thanks a lot!!!

[murugesh]

Can you help me out where i want to set date filter

Case1:
Select Id,
Case_Type__c,
LastModifiedDate,
CreatedDate,
Origin,
Status,
Subject from Case where Date(CreatedDate,'DD-MM-YYYY')>='01-05-2018';

CaseHistory1:
Select Id,
CaseId,
CreatedDate,
Field,
NewValue from CaseHistory where Date(CreatedDate,'DD-MM-YYYY')>='01-05-2018';

CaseTemp:
Load
Id,
Case_Type__c,
LastModifiedDate,
Origin,
Status,
CreatedDate as CaseCreatedDate
Resident Case1
;

CaseHistoryTemp:
Load
Id as CaseHistoryId,
CaseId as Id,
Field,
NewValue,
CreatedDate as CaseHistoryCreatedDate
Resident CaseHistory1
;

TemporaryTable:
Load
Id,
CaseCreatedDate as IntialDate
Resident
CaseTemp;

join (TemporaryTable)

Load
Id,
max(CaseHistoryCreatedDate) as FinalDate
Resident
CaseHistoryTemp
Where
Field = 'Subject'
and Match (NewValue,'URL LINK SENT', 'CSV FILE SENT', 'SELF INSTALLER', 'INSTALLER ACCEPTED')
Group By
Id
;

NWDData:
Load
Id,
NetWorkDays(IntialDate, FinalDate) as NWD
Resident
TemporaryTable
;
Drop Table TemporaryTable;