Hi all, i'm havinf trouble exporting the date of a dtpicker.

1. i have linked the datepicker to a cell in the workbook
2. if the cell is empty the date picker will show "01-01-1900" (otherwise an errors occurs because there is no date)

Please Login or Register  to view this content.
3. the user can change the date but doesnt have to. When the user doesnt change the date i want to export nothing. In other words keep the cell empty. However the IF doesnt seem to work because the cell gets populated with 02-jan-00.
the below code i have tried with several variations.

Please Login or Register  to view this content.

Is there a good way to "not" export the date, but does export when a date is selected in the dtpicker.