Skip to Content
author's profile photo
Former Member

Converting String Date to Date Format

Hope you can help, I am tearing my hair out. I have a 2D table that stores information. I have a field that records a date in the format 03-May-11 (this is a string). However, it is also stored as a number 40666 in a sortkey field. The string field is CLIENT2D.INFO1 and i have tried to use Date({CLIENT2D.INFO1}) to show as a date, which it does, until i want to use it as a parameter i.e. bring records between two dates. It errors and comes up with bad date format.

Is the 40666 number Unix Time? If so is there anyway to convert this to a Date 03/05/11?

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Best Answer
    author's profile photo
    Former Member
    Posted on May 05, 2011 at 08:23 AM

    Try

    CDate({CLIENT2D.INFO1})

    Ian

    Add comment
    10|10000 characters needed characters exceeded