Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this?
Date(Date#([Opportunities Created Time],'MM-DD-YYYY hh:mm:ss'),'MMM-DD-YYYY') as [Created Time]
Try this?
Date(Date#([Opportunities Created Time],'MM-DD-YYYY hh:mm:ss'),'MMM-DD-YYYY') as [Created Time]
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
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
Even MonthName() should work here
=MonthName(Date#([Opportunities Created Time],'MM-DD-YYYY hh:mm:ss'))
Hi Anil
This is the best i see far .
very flexible.
Thank
Paul