Date Format

[mydsworld]

I am trying to generate date in format YYYYMMDD as required by SAP.

Transformation derivation like

StringToDate(DateToString(CurrentDate(),"%yyyy%mm%dd"),"%yyyy%mm%dd")

gives date in the form YYYY-MM-DD

Please advise.

[keshav0307]

set the default date format for that column to YYYYMMDD

[mydsworld]

Where it is to be done, at the DS level or database level.

[ShaneMuir]

I am trying to generate date in format YYYYMMDD as required by SAP.

Transformation derivation like

StringToDate(DateToString(CurrentDate(),"%yyyy%mm%dd"),"%yyyy%mm%dd")

gives date in the form YYYY-MM-DD

Please advise.

Do you really need the output as a date format? Can it just be a string? I would have thought that SAP is not actually expecting a date formatted column rather just a string representing a date?

If its just a string then a simple convert function will work to remove the '-'