Change Date to number

  • Thread starter Thread starter Donald Franklin
  • Start date Start date
D

Donald Franklin

Is there a way to change this date 2004/10/08, to this 041008?
 
Donald Franklin said:
Is there a way to change this date 2004/10/08, to this 041008?
Click to expand...

The date is *stored* internally as a Double Float number, a count of days
since midnight, December 30, 1899. You can display it using any number of
formats. The format for your preferred appearance would be

yymmdd

John W. Vinson/MVP
 
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

Previous Month Date Function 5
Converting Date to Julian 4
date format change when exporting 2
split data 3
Weekday Date based on Week Number 5
Date Diff Issue 4
Find Max Date With Time Stamp 3
Show Maximum number from multiple Fields in a query 4

Back
Top