News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) how to convert string ...

Microsoft Dynamics CRM (Archived)

how to convert string type into date time data type field CRM

(0) Share

Report

Report

Posted on by fariha

65

how i can convert a string to YYYYMMDDMMHHSSFFF dateandtime field

*This post is locked for comments

All responses Img

All responses (5)

Answers Img

Answers (1)

gdas 50,089 on at

Like (0)

Report

RE: how to convert string type into date time data type field CRM

Great ! Could you please close the thread by verifying helpful answer.
fariha 65 on at

Like (1)

Report

RE: how to convert string type into date time data type field CRM

Thanks Goutam,

after splitting string into years,day,month,hrs,min,sec using sub-string function i convert the string pattern into DateandTime in crm using

DateTime dt = new DateTime(Convert.ToInt16(year), Convert.ToInt16(month), Convert.ToInt16(day), Convert.ToInt16(hrs), Convert.ToInt16(min), Convert.ToInt16(sec), Convert.ToInt32(milisec));

its worked absolutely fine for me.
Verified answer

gdas 50,089 on at

Like (1)

Report

RE: how to convert string type into date time data type field CRM

Try with this -

social.msdn.microsoft.com/.../convert-from-string-to-datetime
fariha 65 on at

Like (0)

Report

RE: how to convert string type into date time data type field CRM

Hi Pravin,

Thanks for the reply actually i want to convert the value of string type field into date and time in plugin,

DateTime.Now.ToString("yyyyMMddHHmmss"); this doesnt work for me
Suggested answer

Pawar Pravin 5,231 on at

Like (0)

Report

RE: how to convert string type into date time data type field CRM

Hi Fariha,

Try this one:

JS:

var myStr = "19701029114010"; //your yyyymmddhhmmss value

var date = new Date(myStr.replace(

/^(\d{4})(\d\d)(\d\d)(\d\d)(\d\d)(\d\d)$/,

'$4:$5:$6 $2/$3/$1'

));

Plugin:

DateTime.Now.ToString("yyyyMMddHHmmss");

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,489 Super User 2025 Season 1

#2

Martin Dráb 231,305 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans