Date format changing between cell and textbox

**processchip** · 10-05-2011, 01:07 PM

Hi All

I use the code below to populate a textbox from a work sheet, the Cell B12 has the date in dd/mm/yyyy format and I have set the textbox to change this to dd.mm.yyyy.

Please Login or Register  to view this content.

This works ok for most of the time but today the cell was showing 05/07/2011 and the textbox was showing 07.05.2011. Im sure i'm missing something very simple but not sure what it is.

Can anyone help me please ??

Thanks for looking

Processchip

**TMS** · 10-05-2011, 01:53 PM

I've got a feeling that it will be using American format dates. I'd be inclined to take the separate elements of the date using DAY, MONTH and YEAR and then rebuild the date in the format required (rather than trying to do it in one/two step/s).

Regards

Date format changing between cell and textbox

LinkBack

Thread Tools

Rate This Thread

Display

Date format changing between cell and textbox

Re: Date format changing between cell and textbox

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions