How to convert sting to date(DD-MMM-YY)

[amreesh_singh]

Hi,

I want to convert the string to date(DD-MMM-YY) format. The string is in the following format : 01032008 12:00
I am using StringToDate(DSLink6.EFF,"DD-MMM-YY") but its showing the error
APT_ParseError: Parsing parameters "DD-MMM-YY" for conversion "date=date_from_ustring[%yyyy-%mm-%dd](ustring)": APT_Conversion_String_Date: Invalid Format [DD-MMM-YY] used for string_from_date type conversion.

[ray.wurlod]

Perhaps you should ask Gordon Sumner.

Using StringToDate() you must provide the format of the string - that is, the format in which the string is being provided.

In your case you also need to remove the date component from your longer string that also includes the time.

So you need something like:

Code: Select all

StringToDate(Left(InLink.TheString,8),"%mm%dd%yyyy")

(assuming that your string is in month-day-year order - adapt as required).

[chulett]

Perhaps you should ask Gordon Sumner.

Oy, that took a moment or two to puzzle out.