Convert String to Date 1

[cm1234]

Hi out there

I am running CR 9.0 and have a issue in getting a
string converted to date format.
The string is made in MS sql and i need it to
be visual in CR as a date.
Hope somebody can help me

Best regards
Cm1234

 

[AngelB]

Can you let us know what format the string takes? e.g. dd/mm/yyyy, yyyymmdd or something else?

Thanks


Geraint

The lights are on but nobody's home, my elevator doesn't go to the top. I'm not playing with a full deck, I've lost my marbles. Barenaked Ladies - Crazy

 

[cm1234]

Hi AngelB

thanks for your qiuck response
the format of the string is 2006-10-30 09.20.00
and i only need the date from this, not the time

best regards
Cm1234

 

[AngelB]

Hi again,

In this case the function 'DateValue' will work fine. Your code will be:

DateValue(StringFieldName)

Hope this helps


Geraint

The lights are on but nobody's home, my elevator doesn't go to the top. I'm not playing with a full deck, I've lost my marbles. Barenaked Ladies - Crazy

 

[AngelB]

I should also mention that if it's at all possible that the string could come out in a different format, it would be worth using the IsDate function first to check if the string can indeed be converted. Something like:

If IsDate(StringFieldName) Then
    DateValue(StringFieldName)
Else
    Some default date

Geraint

The lights are on but nobody's home, my elevator doesn't go to the top. I'm not playing with a full deck, I've lost my marbles. Barenaked Ladies - Crazy