• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 264
  • Last Modified:

Convert String to Date

How do I convert the following String to Date with a formula
String "050708"
Where 05 is the day, 07 is the month and 08 is the month
So I would get the output like
05-July-08
0
ranhell
Asked:
ranhell
  • 2
1 Solution
 
ranhellAuthor Commented:
Correction
How do I convert the following String to Date with a formula
String "050708"
Where 05 is the day, 07 is the month and 08 is the year
So I would get the output like
05-July-08
0
 
ranhellAuthor Commented:
I figure it out by myself

Local NumberVar ano;
Local NumberVar mes;
Local NumberVar dia;
if Length ({TEMPIN.CB}) = 30 then
(   dia := tonumber(left(right({TEMPIN.CB},27),2)) ;
    mes := tonumber (left(right({TEMPIN.CB},24),1));
    ano := tonumber (left(right({TEMPIN.CB},23),2))+ 2000;
    datevalue(ano,mes,dia);
)

Else
(   dia := tonumber(left(right({TEMPIN.CB},15),2)) ;
    mes := tonumber (left(right({TEMPIN.CB},12),1));
    ano := tonumber (left(right({TEMPIN.CB},11),2))+ 2000;
    datevalue(ano,mes,dia);
)
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now