Convert number to a date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a textbox that is being autofilled. The number being entered is for
example 12282005. How do I convert this to the date 12/28/2005?
Thank you for your assistance
 
DateSerial( Right([DateText], 4), Left([DateText], 2), Mid([DateText], 3,
2) )
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Which is the best MBOX Converter Tool different formats conversion? 4
How to Convert EML to PST? 2
Windows 7 I need to convert date to text 3
How to Convert MBOX to PST Online? 3
How can we convert OST to PDF file format? 1
Access Dateadd function question.. 0
How to Convert EML to PST in 2025? 2
Voltage supply issue related to NUC PC Core i7 0

Back
Top