# text vers Heure

**URL:** <https://forum.xojo.com/t/text-vers-heure/40907>\
**Category:** Français\
**Created:** [November 29, 2017, 7:41pm UTC](https://forum.xojo.com/t/text-vers-heure/40907 "2017-11-29T19:41:17Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![julien\_assayah](https://forum.xojo.com/letter_avatar_proxy/v4/letter/j/59ef9b/32.png) [@julien\_assayah](https://forum.xojo.com/u/julien_assayah)\
**Post date:** [November 29, 2017, 7:41pm UTC](https://forum.xojo.com/t/text-vers-heure/40907/1 "2017-11-29T19:41:17Z")

</div>

Bonjour,  
je recupere un stringValue du type “15:30:02” pour 15h30 et 02 seconde,  
comment convertir cette chaine au format date pour pouvoir manipuler ma donne…  
je bloque…

merci

---

<div class="post-metadata">

**Author:** ![Jeremie\_L](https://forum.xojo.com/user_avatar/forum.xojo.com/jeremie_l/32/150_2.png) [@Jeremie\_L](https://forum.xojo.com/u/Jeremie_L)\
**Post date:** [November 29, 2017, 7:43pm UTC](https://forum.xojo.com/t/text-vers-heure/40907/2 "2017-11-29T19:43:24Z")

</div>

Bonjour

`Dim d as new Date
d.sqlDate = d.sqlDate + " " + stringHeure`

Ceci devrait crer une nouvelle date ( la date du jour) et l’heure dfinie dans stringHeure.

---

<div class="post-metadata">

**Author:** ![Thomas\_ROBISSON](https://forum.xojo.com/user_avatar/forum.xojo.com/thomas_robisson/32/15868_2.png) [@Thomas\_ROBISSON](https://forum.xojo.com/u/Thomas_ROBISSON)\
**Post date:** [November 29, 2017, 8:26pm UTC](https://forum.xojo.com/t/text-vers-heure/40907/3 "2017-11-29T20:26:21Z")

</div>

Ou avec NthField. Comme a tu fais des contrles si jamais ce texte contiendrait autre chose qu’un heure.  
Du style vrifier que CountField(CeTexte, “:”) = 3  
Puis que Val(NthField(CeTexte, “:”, 1)) est bien compris entre 0 et 24, que Val(NthField(CeTexte, “:”, 2)) entre 0 et 59, idem pour les secondes.  
Puis Dim MaDate as New Date  
Et MaDate.Hour = Val(NthField(CeTexte, “:”, 1)) et MaDate.Minute = Val(NthField(CeTexte, “:”, 2))

---

<div class="post-metadata">

**Author:** ![julien\_assayah](https://forum.xojo.com/letter_avatar_proxy/v4/letter/j/59ef9b/32.png) [@julien\_assayah](https://forum.xojo.com/u/julien_assayah)\
**Post date:** [November 29, 2017, 8:58pm UTC](https://forum.xojo.com/t/text-vers-heure/40907/4 "2017-11-29T20:58:27Z")

</div>

[quote=362177:@JrmieLeroy]Dim d as new Date  
d.sqlDate = d.sqlDate + " " + stringHeure[/quote]  
merci, en fait c’est

`Dim d as new Date
d.sqlDateTime = d.sqlDate + " " + stringHeure`

---

<div class="post-metadata">

**Author:** ![Jean\_Luc\_Pellerin](https://forum.xojo.com/user_avatar/forum.xojo.com/jean_luc_pellerin/32/11479_2.png) [@Jean\_Luc\_Pellerin](https://forum.xojo.com/u/Jean_Luc_Pellerin)\
**Post date:** [November 30, 2017, 12:46pm UTC](https://forum.xojo.com/t/text-vers-heure/40907/5 "2017-11-30T12:46:35Z")

</div>

Tu peux aussi utiliser “FromText”

Using Xojo.Core  
Dim SQLDateTime As Text = “2015-08-01 11:00”  
Dim myDate1 As Date = [b]Date.FromText/b

Dim SQLDate As Text = “2015-06-01”  
Dim myDate2 As Date = [b]Date.FromText/b

Dim dateValue As Text = Date.Now.ToText(Locale.Current)  
Dim myDate3 As Date = Date.FromText(dateValue, Locale.Current)

---

<div class="post-metadata">

**Author:** ![system](https://forum.xojo.com/uploads/default/original/1X/455b4dcc0e61630e9f81940004ddffa49c432a46.png) [@system](https://forum.xojo.com/u/system)\
**Post date:** [October 29, 2020, 7:00pm UTC](https://forum.xojo.com/t/text-vers-heure/40907/6 "2020-10-29T19:00:38Z")

</div>