Dear Avinash, we have identified the date format in createddate at demographic level on Doctor on wheels project.
Please check update it accordingly.
Query:
select createddate,benregid,createdby,lastmoddate,syncedby,synceddate,vanid
from db_identity.i_beneficiarymapping where createddate between '2024-07-22 00:00:00' and '2024-07-25 23:59:59' and vanid=30;