SubField([Created Time],'-' ,3) as Year_CD, How to remove the time ?

[paulyeo11]

Hi All

I have below script :-

[Opportunities Created Time] as      [Created Time],

it will display the date and time :-

01-02-2018 08:27:20

01-04-2016 03:03:46

01-04-2016 03:09:00

01-05-2015 01:18:00

May i know how to make it display as below :-

Jan-02-2018

Jan-04-2016

Jan-04-2016

Jan-05-2015

I have try :-

SubField([Created Time],'-' ,3) as Year_CD,

2014 00:36:19

2014 00:43:42

2014 00:50:23

2014 00:50:54

My question is how to remove those time and make it look like below ?

2014

2014

2014

2014

Also may i know how to add the month inform ? So that i it can display as below :-

Jan 2014

Jan 2014

Jan 2014

Jan 2014

Thank you

[Anil_Babu_Samineni · Accepted solution]

Try this?

Date(Date#([Opportunities Created Time],'MM-DD-YYYY hh:mm:ss'),'MMM-DD-YYYY') as [Created Time]

[paulyeo11]

Hi Anil

Thank you so much for your help. Now your expression display as below :-

Jul-09-2014

How to make it display as Month Year , like below :-

Jul 2014

Paul

[paulyeo11]

Hi Anil

I notice your script very easy to modify :-

Date(Date#([Opportunities Created Time],'MM-DD-YYYY hh:mm:ss'),'MMM-YYYY') as [Created Time_1],

Thank

Paul   

[Anil_Babu_Samineni]

Even MonthName() should work here

=MonthName(Date#([Opportunities Created Time],'MM-DD-YYYY hh:mm:ss'))

[paulyeo11]

Hi Anil

This is the best i see far .

very flexible.

Thank

Paul