Convert String to Date

[anuradhaa]

HI ,

I have this string and i want to convert it to Date,

Jan, 04

Thanks

[settu_periasamy]

Try

=MonthStart(Date#('Jan, 04','MMM, YY'))

[Mark_Little]

Hi,

How is the date formatted?

I.e.

Is it month year January 2014

or 4th January

Also how do you want it to be formatted?

01/01/2004?

Mark

[Anonymous]

Can you please trying this convert option!

=Date(Date#(Jan, 04,'mmm,DD'),'DD/MM')

[its_anandrjs]

Try this ways

=Date(Date#('Jan, 04','MMM, DD'),'MMM, DD')

Regards

Anand

[sunny_talwar]

What format are you trying to convert it into?

May be this:

Date(Date#(DateField, 'MMM, YY'), 'YourDesiredDateFormatHere') as Date

[ramasaisaksoft]

Hi Anu,

select that field into any object and Number format choose as your wish.

else in code level you need to write

Date#(Start_Date,'MM/DD/YYYY') as Start_Date -->converts string to date format

Date(Date#(Start_Date,'MM/DD/YYYY'),'YYYY/MMM/DD') as Start_Date--> Converts date format data into your convenient date format

[HirisH_V7]

Hi,

Check this,

Date:
LOAD *,


Mid(Date,1,3)  as Month,
'20'&Mid(Date,6,8)  as year,
'01/'& Mid(Date,1,3) & '/20'&Mid(Date,6,8) as DateField,
Date#('01/'& Mid(Date,1,3) & '/20'&Mid(Date,6,8),'DD/MM/YYYY') as DateField1


 INLINE [
    Date
    "Jan, 04"
];

can you tell me your exact date format required.

-Hirish

[#9]

Hi Anuradha,

Try this,

Date(Date#('Jan, 04','MMM, YY'),'MM/DD/YYYY')  if you want  date in MM/DD/YYYY format.

You can give other formats according to your requirement.

Regards

[luizcdepaula]

If it is simply a text field, not date formatted already, the syntax above from Lokeshwari works perfectly.

Thanks

LD