I'm using crystal 9 with a csv file:
There is a date and time field that are character datatypes.
Date Time
Tue 07/28/2009 12:59:01.10
How do I create a formula for the date field so it removes the day of the week and space(i.e. "Tue ") and makes it a date field?
How do I create a formula for the time field so it removes the period and the last 2 digits (i.e. ".10") and makes it a time field?
Needed:
Date Time
07/28/2009 12:59:01
Thanks in advance for your help.
There is a date and time field that are character datatypes.
Date Time
Tue 07/28/2009 12:59:01.10
How do I create a formula for the date field so it removes the day of the week and space(i.e. "Tue ") and makes it a date field?
How do I create a formula for the time field so it removes the period and the last 2 digits (i.e. ".10") and makes it a time field?
Needed:
Date Time
07/28/2009 12:59:01
Thanks in advance for your help.