date format issue,request help

[#1]

hi,

I have  a field in the below format.I need to extract the following dates as only monthnames.How could I do please can someone help me out??

eg:1/1/2014 12:00:00 AM= January

    2/1/2014 12:00:00 AM =February etc

fieldA

1/1/2014 12:00:00 AM

2/1/2014 12:00:00 AM

3/1/2014 12:00:00 AM

4/1/2014 9:51:48 AM

1/1/2015 12:00:00 AM

2/1/2015 12:00:00 AM

3/1/201512:00:00 AM

4/1/2015 9:51:48 AM

.......

regards,

Sahana

[sushil353 · Accepted solution]

Hi ,

Try this:

Date(Date#(fieldA,'DD/MM/YYYY hh:mm:ss TT'),'MMMM')

HTH

Sushil

[PrashantSangle]

Hi ,

Try this:

Date(Date#(fieldA,'MM/DD/YYYY hh:mm:ss TT'),'MMMM')

Regards

[#4]

Hi ,

you need to add the below condition into your script

Date(Date#(fieldA,'DD/MM/YYYY hh:mm:ss TT')'MMMM') as MonthName

Regards

Charitha

[senpradip007]

You can use:

Date(fieldA, 'MMMM')

[sushil353]

There is one another way:

Edit your initial variables with full month name

SET MonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

And then simply use:

Month(fieldA)

HTH

Sushil

[#7]

Hi,

Try conversion using this code DATE(DATE#(SUBFIELD(FieldA,' ',1),'MM/DD/YYYY'),'MMM')

[#8]

yes , if you have all the data is in the same format (dd/mm/yyyy) then no need to use date#, directly we can apply date() on specific otherwise need to convert the date into same format of all values.

-Charitha

[senpradip007]

Hi Lakshmi,

As Sahana did not mention that the date can be in dual format, I'm using only date(). Otherwise date# will come into play.

-PS