Getting this error in date

[katta_nikhil]

someone tell me this error

[Anil_G (Anil Gorthi)]

@katta_nikhil

You need to use .ToString("MM/dd/yyyy")

Also what is latestdate?

Is it a datarow type?

Because you are giving latestdate("Column")

Cheers

[Yoichi]

HI,

How about the following expression?

if(Double.TryParse(latestdate("Column-2").ToString,New Double), DateTime.FromOADate(Double.Parse(latestdate("Column-2").ToString)).ToString("MM/dd/yyyy"),CDate(latestdate("Column-2")).ToString("MM/dd/yyyy"))

Regards,

[katta_nikhil]

yes it is datarow

@Anil_G you only gave me this expression bro

[katta_nikhil]

still getting error

[Anil_G (Anil Gorthi)]

@katta_nikhil

I beleive the left variable is a data type…please change it to string…out_LatestDate

If you want as date then you can remvoe .ToString(…) completely from both expressions

For reference… Expression is little different without .ToString only

Change date

@katta_nikhil this is to use in a loop when retreiving data from datatable and not as is this is how you can use…if you want to only use in activities soemwhere then use the value part or like in log message…if you need to update the values in the datatable then use like assign [image] cheers

cheers