convert

[smilingjohn]

I have a Excel sheet , in which the month names are in text like Jan, feb , mar and so on

How do i convert this to Date ?

[vikasmahajan]

Put this in script

Date(date#(month,'YYYYMM'),'DD-MM-YYYY') as PostingDate

Vikas

[sunny_talwar]

May be like this:

Month(Date#(Captialize(month), 'MMM')) as Month

[Chanty4u]

try

Date(Date#(Datefield,'MMMDDYYYY'),'YY-MM-DD') AS newdate

Date(Date#(Datefield,'urdatefieldformat'),'reuireddateformat') AS newdate

[yadhunandhanan]

Hi John,

How about this,

=Date(Date#('15-Jan-16','DD-MMM-YY'),'DD-MM-YY')

Replace '15-Jan-16' as your date field.

Hope its help.

[smilingjohn]

Hi vikas  thanks

In a excel sheet i have Months vertical

Below is the example of the column under excel sheet.

ID ,Dept,Amount, Year,Jan,Feb,Mar,Apr,May....... Dec

1,  Soap, 12,  2010   23, 24,1,12,.,.,.,.,.

2 ,Cosmatics,100,, 2010 ,11,22,2

This is how i have the excel sheet , where year has no problem  only month is horizontal and in text format

How do i deal with this ,

Regards

.

[#7]

Try thissmilingjohn

=date(Month,'DD-MM-YYYY') as DATE

[sunny_talwar]

You need to implement a CrossTable Load here:

The Crosstable Load

[Chanty4u]

use  Crosstable for that then u can create date filed as abve mentoned

[vikasmahajan]

After implementation of cross table , load script with  Date(date#(month,'YYYYMM'),'DD-MM-YYYY') as PostingDate

This should solve your problem

Vikas