date format -- another question 1

[deadfish]

Hi,
Suppose I have a string which I know it is a string containing a date with dd/mm/yyyy format.

How to convert it to a datetime? (CDateTime seems doesn't work in some case when the string is "01/02/2004", it will read as "02 Jan 2004" if the date format is set to mm/dd/yyyy in Regional Options in Windows)

Thanks in advance!

 

[MJRBIM]

NAME : {@ConvertToDateTime}

FORMULA : DateTime ((ToNumber (Right ({DateString_txt.dd/mm/yyyy},4))),
(ToNumber (Mid ({DateString_txt.dd/mm/yyyy},4 ,2 ))),
(ToNumber (Left ({DateString_txt.dd/mm/yyyy},2))),
0, 0 ,0 )

- - - - - - - - - - - - - - -

Replace the {DateString_txt.dd/mm/yyyy} with your {Table.Field}.

 

[deadfish]

It works! Thank you very much MJRBIM!

 

[minditx]

Thanks MJRRBIM..it work while i have same problem with deadfish. how about if i want get month only. it that same formula or another.

 

[dgillz]

Monthname(<<Insert MJRRBIM's Formula here>>)

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[dgillz]

Oops,

Make that:

Monthname(Month(<<Insert MJRRBIM's Formula here>>))

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com