StringToTimestamp err

[bart12872]

The format must not be dependant on the version.

well, as it is write in the Help "Date, Time, and Timestamp functions that take a format string (e.g. timetostring(time, stringformat)) need specific formats."
It seems that the day and the month must be on 2 digits.

[betterthanever]

bart12872,
we can handle single digit month and date as mentioned in the expessions ...

i agree that the expression you mentioned also works..

[efxuser]

StringToTimestamp(Right('0':Field(DSLink8.Eff_date,'/',1),2):'/':Right('0':Field(DSLink8.Eff_date,'/',2),2):'/':Field(DSLink8.Eff_date,'/',3) :' 00:00:00',"%mm/%dd/%yyyy %hh:%nn:%ss")


this expression works but just waiting for someone to jump in with a elegant solution.Thanks for all the poster's time and help.

[bart12872]

Here is your answer.

viewtopic.php?t=117884&highlight=StringToTimestamp

[efxuser]

thanks very much

[newmoonera]

Wats the datatype of the field you are using...?

[dr.murthy]

Hi,

use a isvaild function to get the date values which is having proper format means dd-mm-yyyy.you can deal with rest of the dates by prefix 0.

[dr.murthy]

Hi,

use a isvaild function to get the date values which is having proper format means dd-mm-yyyy.you can deal with rest of the dates by prefix 0.

[ray.wurlod]

Attention to detail!

There is no function called "isvaild".

Further, your assertion that the "proper" format of dates is dd-mm-yyyy is only correct if this is the default date format string.