convert to date

dataservices job design
1

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


date.png

Faabris (BOB member since 2015-11-10)

2

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.

eganjp :us: (BOB member since 2007-09-12)

3

hi Jim,

thanks for the answer, I’ll try it :slight_smile:

Faabris (BOB member since 2015-11-10)