Convert 14 digit-decimal to Date

[xarapre7]

Hi All!

I have 14 digit values which is in decimal ( StartDate = 20160128155600) which i need to convert to Date.

I've used Date(Date# (StartDate, 'YYY-MM-DD'), 'YYY-MM-DD') as 'Start Date' but it didn't return anything. 

Can you please assist me with this?  Thank you in advance.

[sunny_talwar]

May be this

Date(Date#(Left(StartDate, 8), 'YYYYMMDD'), 'YYYY-MM-DD') as StartDate

[trdandamudi]

May be as below:

=Date#(Left( 20160128155600,8),'YYYY-MM-DD')

[xarapre7]

Thank you Sunny T!  It worked.

[sunny_talwar]

Awesome, please close the thread by marking correct response.

Best,

Sunny