Skip to Content
avatar image
Former Member

how to send month as string to date

Hi

my input comes as

month year.( oct 2008 or Nov 2008 etc )

The target field is a Date.

I have tried using Date trans but it doesnt accept strings.

so is there a way send the incoming field without changing target data to string?

Regards,

Venkat.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Dec 01, 2008 at 10:49 PM

    Hi Venkat,

    If you get value Oct 2008, what will be the date field value is it (01-Oct-2008)?

    regards

    Unni

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      Use Date transformation funtion in mapping

      To accept the string month ,You can use source format as --- dd-MMM-yyyy or dd/MMM/yyyy

      And the target format as you required format Ex: dd/mm/yyyy or dd-mm-yyyy

      REgards

      Seshagiri

  • avatar image
    Former Member
    Dec 02, 2008 at 05:48 AM

    Hi,

    This is possible using Date Trans function.

    src-->TransformDate->tgt

    Format of Source Date - MMM yyyyy

    Format of Target Date - MMM/yyyy

    Add comment
    10|10000 characters needed characters exceeded