Start Date and End Date are same and Job failed to import Users

[sandeepgudipudi]

There are users whose Start Date and End Date are same and while importing Users the Job failed to import Users due to same date in start and end date field. Is there a way to ignore the restriction of checking start and end dates

[Raghu]

Reason of failure job in logs?

[rushikeshvartak]

This is known behavior. Use preprocessor to change end date to end date +1 using preprocessor  

[sandeepgudipudi]

Can you provide preprocessor query if startdate and end date is same, change end date to end date+1

[rushikeshvartak]

Sample

{
"ADDITIONALTABLES": {
"USERS": "SELECT username, enddate FROM USERS"
},
"COMPUTEDCOLUMNS": [
"enddate"
],
"PREPROCESSQUERIES": [

"UPDATE NEWUSERDATA SET NEWUSERDATA.enddate = DATE_ADD(NEWUSERDATA.enddate, INTERVAL 1 DAY) WHERE NEWUSERDATA.startdate = NEWUSERDATA.enddate"
]
}