DSXchange

Sainath.Srinivasan wrote: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.

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

i agree that the expression you mentioned also works..

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.

Here is your answer.

viewtopic.php?t=117884&highlight=StringToTimestamp

thanks very much

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

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.

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.

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.