CODE EXAMPLE FOR JAVASCRIPT

google script get date without time

setValue(new Date(new Date().setHours(0,0,0,0))).setNumberFormat('MM/dd/yyyy');