Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be this
Date(Date#(Left(StartDate, 8), 'YYYYMMDD'), 'YYYY-MM-DD') as StartDate
May be as below:
=Date#(Left( 20160128155600,8),'YYYY-MM-DD')
Thank you Sunny T! It worked.
Awesome, please close the thread by marking correct response.
Best,
Sunny