Convert to date time

[mhamurcuoglu]

Hi

How convert nvarchar to date/time format

my format 20141210 1217  I want 10/12/2014 12:17

I m sorry for my English

Thanks

[mrossoit]

=date(date#('20141210 1217', 'YYYYMMDD HHmm'), 'DD/MM/YYYY HH.mm')

[ankitaag]

Hello Mehmet,

Try this:

=Date(Date#('20141210 1217','YYYYMMDD hhmm'),'DD/MM/YYYY hh:mm')

This will give you the result as: 10/12/2014 12:17

Thanks and Regards,

Ankita

[rajkumarb]

HI

Use Previous said methods by Massimilliano & Ankita

Go through this Document It Is Very Helpfull

[#5]

hi,

use date function for this.date(date#('20141210 1217'), 'DD/MM/YYYY HH.mm')

if date function is not working then use makedate()

Date=20141210 1217

date(makedate(left(Date,4),mid(Date,5,2),mid(Date,7,2)),'DD/MM/YYYY') as Date,

maketime(mid(Date,11,2),mid(Date,13,2) as time   ----(hh:mm) formate

Regards

Vimlesh

[jagan · Accepted solution]

Hi,

Try like this

=Timestamp(Timestamp#('20141210 1217', 'YYYYMMDD hhmm'), 'DD/MM/YYYY hh:mm')

Hope this helps you.

Regards,

jagan.

[PrashantSangle]

Hi,

You can use timestamp() and timestamp#()

try

=timestamp(timestamp#(DatefieldName,'YYYYMMDD hhmm'),'DD/MM/YYYY hh:mm')

Regards

[nagarjuna_kotha]

Hi,

try this .I Hope this will work.

=Timestamp(Timestamp#('20141210 1217', 'YYYYMMDD hhmm'), 'DD/MM/YYYY hh:mm')

Regards,

Nagarjuna