date and text format

Hi Experts I have been through so many potential breakthroughs in the past week via the net/forums/handbooks etc but cannot for the life of me find the exact code needed to return "dd/mm"yyyy" to my textboxes when i intend on updating exsiting data within my form. Basically I have a textbox...

Hi All, What I am trying to do is sort data by date. I have data in the following format No. Project Information Job 1 Date % Complete Resource 1 P395A2 BHL Tier 4 Final (US) 68kW Fri 29/05/15 96% Shaun The column 'Job 1 Date' needs to become the column...

Hi, How would you get a vba defined string e.g. "050914" to be ouput in a cell as "05/09/2014" (or just "05/09/14") It must be classed as an actual date, not just a string in the cell for sorting and ordering etc. Thanks in advance.

I have a form with a date field that doesn't check if an actual date has been entered - and won't check with my coding. It lets you type anything into it. I initialise the form by setting the fields to empty, and the code for the DATE field is as follows: txtDOB.Text = Format (Now -...

<TBODY> 10.2013</SPAN> 1</SPAN> 01.10.2013 </SPAN> 201310</SPAN> 001</SPAN> Oct 13</SPAN> 11.2013</SPAN> 2</SPAN> 01.11.2013</SPAN> 201311</SPAN> 002</SPAN> Nov 13</SPAN> 12.2013</SPAN> 3</SPAN> 01.12.2013</SPAN> 201312</SPAN> 003</SPAN> Dez 13</SPAN> 01.2014</SPAN>...

I am trying to use Excel 2010 as a data source for a Word 2010 mail merge. I am pulling several text fields and date fields. One of the text fields (a city name) always comes out as 12:00:00 AM. One of the text fields always shows as 0. Other text fields work correctly. The fields in Excel...