Hi @Lee Yong Sheng ,
Welcome to Microsoft Q&A Platform. Thank you for the question.
Please run the query without where clause and see if you are able to get the result,
Because query that you are using seems correct,
DateTimeDiff (<DateTimePart> , <StartDate> , <EndDate>)
Example:
SELECT DateTimeDiff("day", "2020-01-01T01:02:03.1234527Z", "2020-01-03T01:02:03.1234567Z") AS DifferenceInDays
Refer the MS documentation
Regards,
Kamlesh Kumar
BizTalk Techie
Please don't forget to click on or upvote
button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is How
Want a reminder to come back and check responses? Here is how to subscribe to a Notification
If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators