Regarding Date conversion

[satishm]

Hi,
Can some one assist in converting a date from one format to another.

eg:
Input Date : 2009-12-31 ( yyyy-mm-dd) data-type : Date

Output Required : 31-12-2009 ( dd-mm-yyyy) data-type : Date

Regards,
SatishM.

[chulett]

A date is a date, only date values in string fields have formats like you are showing. You can use "[]", the substring operators, to re-arrange the parts of those external dates or the StringToDate / DateToString functions.

[ray.wurlod]

Dates do not have formats. Dates are stored in binary format.

[vishal_rastogi]

Hi,
Can some one assist in converting a date from one format to another.

eg:
Input Date : 2009-12-31 ( yyyy-mm-dd) data-type : Date

Output Required : 31-12-2009 ( dd-mm-yyyy) data-type : Date

Regards,
SatishM.

you can convert first date to string then and then again string to date

[chulett]

No reason for anything like that, if both the source and target are a "date" data type as (as noted) there are no format to dates, they are stored internally in binary. Now if only one end or the other is a Date or there are two Strings involved then those functions are the way to go.