I have to + 11:30 hr to the date (3/23/2020 12:46:00 AM). Then date format will be MM/DD/YYYY
Ex: enter image description here used forma in excel =Text(date+"11:30:00","MM/DD/YYYY")
How this will do in IIF condition in MS Access?
If you mean to add 11:30 to the date of that date/time value in Access, it could be:
NewDateTime = Int(OldDateTime) + #11:30:00#