DateValue 1

[TechUser23]

I still relatively new to Crystal. I need to convert a string field into datetime so I can format it accordingly.

My issue is I found another instance with a formula being used and now my Date (07/14/2006) is reporting back 07/09/2006.

DateValue (Left ({Data.Date},19 ))

Can anyone help shed light on this for me? What does the "19" mean to me and are there more #'s to look at?

 

[synapsevampire]

You need to post what the string format of your date is, we don't know what it's storedlike, and you should include your Crystal version and the database.

As for the 19 in the above, that means the first 19 characters starting from the left.

-k

 

[TechUser23]

Maybe this would be easier:

Currently its displaying as such:

2006/07/14 00:00:00.00

I want to read:

07/14/2006

 

[synapsevampire]

From what I can tell, you can use:

date(val(split({table.string},"/")[1]),val(split({table.string},"/")[2]),val(split(left({table.string},10),"/")[3]))

-k

 

[TechUser23]

Amazing - thanks a million.