BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: Upcoming Events: PGHBOUG: Oct 19.

convert to date


 
Search this topic... | Search DI: Designer and Job Design... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Author Message
Faabris
Forum Member
Forum Member



Joined: 10 Nov 2015

Posts: 2



PostPosted: Thu Jan 11, 2018 6:57 am 
Post subject: convert to date

Hi,

I have following date format in varchar (See attachement):

01.11.17
02.11.2017
03NOV17
04NOV2017
2017-11-05
06-11-2017
07-11-17

how can I convert to date format (yyyy-mm-dd) in BODS?
how can I Creating a custom function?

can anyone help me?
Thanks in advance
fabi

[img][/img]
Back to top
eganjp
Forum Addict
Forum Addict



Joined: 12 Sep 2007
ASUG Icon
Posts: 4278
Location: Denver Area


flag
PostPosted: Fri Jan 12, 2018 2:02 pm 
Post subject: Re: convert to date

I would probably use a custom function to convert the string to a date. You'll have to go through a number of rules to find the right date mask to use. The last thing in the function should be to validate the string using the date format.
_________________
Jim Egan
ProKarma-an SAP Consulting Partner
Speaker at RMOUG Training Days 2013
Speaker at Sapphire Now 2013
Speaker at Business Objects User Conference 2013
-My ETL is faster than your database! - Advanced ETL performance tuning for Data Services
-Kill ETL bugs before they kill you!
My ETL blog

Latest Blog Posts
• 2014-04-17 Can Your ETL Make Your Reporting Faster?
• 2014-04-04 ProKarma Acquires Mantis Technology Group
• 2014-04-02 How to Create Charts in Webi (Part 2 of 2)
Back to top
Faabris
Forum Member
Forum Member



Joined: 10 Nov 2015

Posts: 2



PostPosted: Tue Jan 16, 2018 9:25 am 
Post subject: Re: convert to date

hi Jim,

thanks for the answer, I'll try it icon_smile.gif
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0304 seconds using 17 queries. (SQL 0.0030 Parse 0.0009 Other 0.0265)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo