Page 1 of 1
Date Format
Posted: Tue Apr 29, 2008 8:38 pm
by 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.
Posted: Tue Apr 29, 2008 8:52 pm
by keshav0307
set the default date format for that column to YYYYMMDD
Posted: Tue Apr 29, 2008 8:59 pm
by mydsworld
Where it is to be done, at the DS level or database level.
Re: Date Format
Posted: Tue Apr 29, 2008 9:24 pm
by ShaneMuir
mydsworld wrote: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 '-'