Formating Text to Date 1

[Evil8]

Is it possible to take a text string 01/01/09 and make it a date yyyymmdd?

Thank you for your time,
Evil8

 

[MajorGap]

cdate ({Your Field}) will give you a date. You can then format it any way you want. You can use isdate to check if any field is compatible with a date. It will return "True" or "False

 

[Evil8]

Thanks for your help. I tried this in the field Display String property and got an error - The formula result must be a string. I also tried it as a formula field and got a bad date format string error.

Could the error be caused by null field values?

 

[chelseatech]

Display String must create a string.

Try toText( cdate ({Your Field}),"yyyyMMdd")

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[Evil8]

That worked! Thanks alot!