473,388 Members | 1,574 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,388 software developers and data experts.

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
Aug 26 '10 #1
1 3555
Dear Use following code in formula field.

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

a:=Mid (dt,1,1)
Sep 1 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Jason Chan | last post by:
I am beginner on Crystal Report. I want to ask a basic question. How can i display a report in ASP? I search for many web and try the sample from crystal dicussion but no luck, the code does...
0
by: Omavlana | last post by:
Hi, pls clarify these 2 questions. 1. How can I send some values of globla variables from VB.NET to crystal report. I want to show these values on report. 2. I have added an SQL query in my...
2
by: ferit meftun harmankaya | last post by:
I have some report which are designed in "Crystal Report". I want to run these reports in "Reporting Service" My aim is to convert from extension of Crystal Report (rpt) to extension of reporting...
0
by: project | last post by:
I want to print an sales invoice with out open crystal report. I want to know ,with out opening Crystal report, how can I give the command to be printing invoice. I'm using the following lines...
0
by: bonita | last post by:
In my ASP.NET page, I have 2 checkboxes for users to choose which crystal report they want to display. These two reports use different tables. If report1 has been choosen and displayed in the...
3
by: nithya jayaraman | last post by:
Hi, pls clarify these questions. 1. How can I send some values of globla variables from VB to crystal report. I want to show these values on report. my database in MS Access My query...
3
by: ranesmitas | last post by:
hello, i using vb 6 and i did report seagate crystal report . i want to know how it use in vb . i did some code but it not display anything code is Public strReportPath As String Public...
12
by: Rajib27 | last post by:
Hi I am using VB2005 As Font end and Sql server 2005 express edition as Back end. I want to get direct Printout from VB2005 Using Crystal report. I want 3 reports to print out on a click Original...
0
by: shaiful | last post by:
Hi all, I never use crystal report. I want to use crystal report in vba. how i should i start? and what is the proceess pls? such as i have a table Emp with field: empName,empID,empAddress. I want...
10
by: kkshansid | last post by:
i have to split adress like raj,2d-raja road,delhi-10008. to raj, raja road, delhi-10008. i can do it with split function but its giving error msg Dim x(3) As String x = Split ({std.addr},...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.