Skip to Content (Press Enter)
2018-11-06 14-26-44
Suraj Borade
4807Views
4Comments
Text to date conversion
Question
Hello Community,

I am reading values from notepad and storing into entities. Date values are in this format YYYYMMDD (20150410). At the time of storing, I am using this function TextToDate() but values are not getting stored.

Any suggestions?

Thanks,
Suraj Borade
0
0
04 Nov 2015
Copy Link
2016-04-21 20-09-55
J.
 
MVP
if you would read the manual, chances are the format is incorrect.
Check for example if the TextToDateValidate returns true or not.

If it's false, you have to create an alternative or check out the forge.

0
0
04 Nov 2015
Copy Link
UserImage.jpg
freek
Hi Suraj,

Maybe you can use index and subtr to convert YYYYMMDD to YYYY-MM-DD that should work with the texttodate function.

Substr("string",0,4)+"-"+Substr("string",5,2)+"-"+Substr("string",7,2)


Good Luck
1
0
04 Nov 2015
Copy Link
UserImage.jpg
Pier Paolo Annis

Hi Freek,

I used your solution, I only changed 5 with 4 and 7 with 6:

Substr("YYYYMMDD",0,4) + "-" + Substr("YYYYMMDD",4,2) + "-" + Substr("YYYYMMDD",6,2)


thanks 

1
0
15 Jul 2021
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.