It should be validation errors in json right?

← prev | next →

Contents:
I know, How is it related?
It should be validation errors in json right?
Hey Is there anyone online?
in what language?

rohit267 2021-01-31 14:10:29

Hila Herman 2021-01-31 14:08:23

I know, How is it related?

learn you will know

phinx_de 2021-01-31 14:12:02

rohit267 2021-01-31 14:09:50

run it, what’s the issue

It returns nothing cause probably there is no end date specifically for ’05-31-2016′

phinx_de 2021-01-31 14:12:17

Need your help please

phinx_de 2021-01-31 14:13:06

rohit267 2021-01-31 14:18:37

phinx_de 2021-01-31 14:13:06

my choice is always to use epoch timestamp instead of date, anyway, try getting one side first >= if it is a date field

phinx_de 2021-01-31 14:20:54

rohit267 2021-01-31 14:18:37

my choice is always to use epoch timestamp instead of date, anyway, try getting one side first >= if it is a date field

phinx_de 2021-01-31 14:20:57

Yes sir, it is a date field, here is the result

rohit267 2021-01-31 14:23:22

phinx_de 2021-01-31 14:20:54

looks like some anomaly in SQL, refer stack overflow for more references

phinx_de 2021-01-31 14:27:31

rohit267 2021-01-31 14:23:22

looks like some anomaly in SQL, refer stack overflow for more references

Thanks, Rohit. I have a sample solution, but still has a small error

phinx_de 2021-01-31 14:27:43

SELECT PolicyReference FROM dbo.Policy
WHERE
(StartDate BETWEEN ‘2016-05-01’ AND ‘2016-05-31’) OR (EndDate BETWEEN ‘2016-05-01’ AND ‘2016-05-31’) OR
(StartDate <= ‘2016-05-01’ AND EndDate >= ‘2016-05-31’)

phinx_de 2021-01-31 14:28:23

tried this and it still includes the policy that has enddate of ’05-01-2016′

rohit267 2021-01-31 14:28:59

phinx_de 2021-01-31 14:28:23

tried this and it still includes the policy that has enddate of ’05-01-2016′

remove the = operator

phinx_de 2021-01-31 14:32:40

rohit267 2021-01-31 14:28:59

remove the = operator

Still got the error, anyway will try other logic thanks very much

nikhil_ev 2021-01-31 19:28:52

Hi in laravel 8 i created a api route and controller.. but when i called validate method it redirects to home page.. I tried in postman.