• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1071
  • Last Modified:

Crystal Reports 2008 - Formula for Date String

Hi and thanks

I have this formula:
Left({TEMP_PWC_Sales_Report_SP_MAIN.mtransferdate}, CStr({TEMP_PWC_Sales_Report_SP_MAIN.mtransferdate}, " ") -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
0
Amour22015
Asked:
Amour22015
1 Solution
 
CodeCruiserCommented:
I am not sure if you can use Split method in CR but give it a try

Split(varname, " ")(0)
0
 
Jared_SCommented:
There is a built-in date function for this.

date({TEMP_PWC_Sales_Report_SP_MAIN.mtransferdate})
0
 
mlmccCommented:
You can use the Split function but it is

Split({YourFieldName}," ")[1]

mlmcc
0
 
Amour22015Author Commented:
Just what I am looking for, Thanks
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now