12.10.2023
15:59
hi
I have datetime type fields i.e From and To ,
i want to check in current db table (WFElements), if datetime exist or not between two dates validating on form submit path using sql query.
Issue: all the time showing validation error message ,
My validation Sample below:
select case
when
(
SELECT count(*)
FROM [BPS_Content_Prod].[dbo].[WFElements]
where wfd_attchoose1='{1189}' and (('{L:1191}' between WFD_AttDateTime1 and WFD_AttDateTime2)
or ('{L:1190}' between WFD_AttDateTime1 and WFD_AttDateTime2)) AND WFD_DTYPEID=17
) > 0
then 0
else 1
end as test
The above query works well in SQL, but issue on the form submit path.
Regards,
