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.
Date Format
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
Re: Date Format
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?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.
If its just a string then a simple convert function will work to remove the '-'