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,
StringToDate() issue in transformer stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
CurrentDate() is not a string, so Convert() will not work on it. Leave it out.
Code: Select all
DateToString(CurrentDate(),"%yyyy%mm%dd")
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
HemaV wrote:I need to check on project default date format once because StringToDate() function is now working for me...
![Confused :?](./images/smilies/icon_confused.gif)
"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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: