stored it to ms access field with data type (date/time)how do i storeMM/DD/2014 only

and3:15pm only

Not sure how you can define time in NeoBook's Date type variable ... but you might try appending the time to [FormattedDate] before passing it to the Access DB field.

other workaround i did to my other program was set data type to "text"..wednesday 12/11/2014

works ok, but i cant sort ascending / descending the dates properly..it sorts to alphabetically..

You can store two fields in the Access DB ... the first one like you have (text field with MM/DD/YYYY for human consumption) ... and another (hidden from user view) that contains the the variable used with DefineVar ... in above example [Birthdate (whose value like 1234789417247 is the "elapsed number of days since some very old date like December 31, 1899") ... do your sorts on the second field