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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.