Date formating help needed
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 103
- Joined: Fri Jan 18, 2008 12:55 am
- Location: chennai
Date formating help needed
How to convert mm/dd/yyyy to yyyy-mm-dd in transformer stage.I dont want to use substring
-
- Participant
- Posts: 103
- Joined: Fri Jan 18, 2008 12:55 am
- Location: chennai
What did you try? Can you post what is causing your compiler errors?
The formats are all in the online help, for example find IConv function (BASIC) in the Index, go there, scroll down to the Date Conversions section and then click on the "D" for a detailed description of that code and how it is used.
Don't forget you can inline the two functions, call one inside the other, so both easily work on the same input data.
ps. This is core Server stuff, you need to learn how to use IConv/OConv to convert your data, especially dates. I don't believe in Silver Platter answers, you'll learn more and it will stick way more better if we nudge you in the right direction and you work the rest of it out for yourself.
The formats are all in the online help, for example find IConv function (BASIC) in the Index, go there, scroll down to the Date Conversions section and then click on the "D" for a detailed description of that code and how it is used.
Don't forget you can inline the two functions, call one inside the other, so both easily work on the same input data.
ps. This is core Server stuff, you need to learn how to use IConv/OConv to convert your data, especially dates. I don't believe in Silver Platter answers, you'll learn more and it will stick way more better if we nudge you in the right direction and you work the rest of it out for yourself.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 103
- Joined: Fri Jan 18, 2008 12:55 am
- Location: chennai