Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2010
    Posts
    2

    Unanswered: Convert Numeric Value To Date Format

    my table has a column StartDates with values like
    ...
    20100331
    20100430
    ...

    these are numeric values of dates.
    i need to create a calculated field query where [StartDate] 20100331 will be shown as 31/03/2010.

    how can i do this?

    (no, i am not authorized to change the field format of StartDate)

  2. #2
    Join Date
    Nov 2009
    Posts
    49
    On the query use CDate(<<expr>>)

    So the name of the field would be - Start Date: CDate(StartDate)

    Think thats all you need to do.

  3. #3
    Join Date
    Jan 2010
    Posts
    2
    Thank you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •