cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
thunter
Level 8

Exclude time from Date Picker

I have a form with 2 Date Picker controls, one is for the Start Date and one is for the End Date, however, when the form is submitted it shows the date and time in my Excel table. the column is formated as a Date. Is there away to exclued the time, as I only want to show the date.

2 REPLIES 2
summitb
Level: Powered On

Re: Exclude time from Date Picker

Have you tried applying the needed date format to sheet itself

thunter
Level 8

Re: Exclude time from Date Picker

Yes, I have the cells for the date columns formatted as date with mm/dd/yyyy. so not sure how to exclude the time.