How to convert date format DD-MM-YYYY into Year ?

[paulyeo11]

How to convert date format DD-MM-YYYY into Year ?

Hi All

I have import a raw data file from Excel to Qli View.

I try to convert the imported field name = [Expected Close Date] in order year format YYYY.

I have try to using the below expression :-

//   text(right(Year(date#([Expected Close Date],'DD/MM/YYYY')), 2),'00') as Year,

//   dual(right(Year(date#([Expected Close Date],'DD/MM/YYYY')), 2),'00') as Year,

//   year(today()) - year([Expected Close Date]) + 1                                         as Year,

//   num(right(Year(date#([Expected Close Date],'DD/MM/YYYY')), 2),'00') as Year,

//   dual(right(Year(date#([Expected Close Date],'DD/MM/YYYY')), 2),'00') as Year,

//   Right(year([Expected Close Date]),2)          as Year,

All the above not able to work.

Can some one advise me.

Paul Yeo

[Anil_Babu_Samineni]

Please try by yourself using existing one, Anyway this?

Num(Month(Date#([Expected Close Date], 'MM-DD-YYYY'))) as Month

[paulyeo11]

Hi Anil

Thank you very much , it work now.

Paul

[rygreene3]

This worked for me!  Thank you, Anil