Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Put this in script
Date(date#(month,'YYYYMM'),'DD-MM-YYYY') as PostingDate
Vikas
May be like this:
Month(Date#(Captialize(month), 'MMM')) as Month
try
Date(Date#(Datefield,'MMMDDYYYY'),'YY-MM-DD') AS newdate
Date(Date#(Datefield,'urdatefieldformat'),'reuireddateformat') AS newdate
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.
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
.
You need to implement a CrossTable Load here:
use Crosstable for that then u can create date filed as abve mentoned
After implementation of cross table , load script with Date(date#(month,'YYYYMM'),'DD-MM-YYYY') as PostingDate
This should solve your problem
Vikas