how to split a date field in crystal report if it is 23/08/2010...i want 2 3 0 8 2 0

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • tomy1980
    New Member
    • Aug 2010
    • 1

    how to split a date field in crystal report if it is 23/08/2010...i want 2 3 0 8 2 0

    how to split a date field in crystal report...
    for example
    if the date is 23/08/2010
    i want it separated and stored in different bdifferent variables like
    a = 2
    b=3
    c=0
    d=8
    e=2
    f=0
    g=1
    h=0
  • mabubakarpk
    New Member
    • Feb 2007
    • 62

    #2
    Dear Use following code in formula field.

    stringVar dt:=totext("25/01/2010") ;
    stringVar a;

    a:=Mid (dt,1,1)

    Comment

    Working...