Amour22015
asked on
Crystal Reports 2008 - Formula for Date String
Hi and thanks
I have this formula:
Left({TEMP_PWC_Sales_Repor t_SP_MAIN. mtransferd ate}, CStr({TEMP_PWC_Sales_Repor t_SP_MAIN. mtransferd ate}, " ") -1)
I get error:
A number, currency amount, date, time, or date-time is required here
what I am trying to do:
|01/01/2012 12:01:01| = |01/01/2012|
Thanks
I have this formula:
Left({TEMP_PWC_Sales_Repor
I get error:
A number, currency amount, date, time, or date-time is required here
what I am trying to do:
|01/01/2012 12:01:01| = |01/01/2012|
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can use the Split function but it is
Split({YourFieldName}," ")[1]
mlmcc
Split({YourFieldName}," ")[1]
mlmcc
ASKER
Just what I am looking for, Thanks
Split(varname, " ")(0)