DSXchange

Hi All,

I used StringtoDate function in transformer stage as below:

StringToDate(Convert('-','',CurrentDate()),"%yyyy%mm%dd")

But in the target date still comes with yyyy-mm-dd format. Unable to understand the issue.

Thanks in Advance,

1)I hope The default date format is yyyy-mm-dd in your project and If you need some other format use DatetoString function but the output will be of type string type.

CurrentDate() is not a string, so Convert() will not work on it. Leave it out.

Thanks All....

DateToString() function works but how can i convert the datatype of string to date as my target column in db is having date datatype .

I need to check on project default date format once because StringToDate() function is now working for me...


Thanks,

HemaV wrote:I need to check on project default date format once because StringToDate() function is now working for me...

"now" = "not"?

There's no need to check on anything as dates don't have a particular format - strings do but dates do not. If you know what format your string date is in, then use that in the StringToDate function and you'll be golden.

Data type Date is stored in a four-byte binary format.