How to select just the date and add

shabeer shaik

please assist me with the following;

previously we had to add 15/12/2012 and we gpt a total 4

now i need to just add the date which is 15 = 1+5 = 6

i have the date in label1
i need text box 6 to equal 6

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes14y ago
Accepted answer
If the date will always be in mm/dd/yyyy format, then replace this line:

string date = label1.Text.Split('/')[0];

with this one:

string date = label1.Text.Split('/')[1];
0
Vulpes14y ago
This link may help:

http://cleancode4devs.blogspot.co.uk/2012/01/import-data-from-excel-to-sqlserver.html

Instead of selecting all columns, I'd trying selecting the name of the column you want (use the Excel column header for this purpose).
0
shabeer shaik14y ago
Hallo Valpes

Can u help me with this . I have gone tru google and some of the refer in this site but i cannot find anything.

I have in Excel 2003 the following

APPROACH ME 80 BL AL 60KG
HAPPY AL 60 BL 60KG

As you can see the text to columns wont work.

I need just APPROACH ME AND HAPPY AL and dnt need the rest

Can you help please.
I normally export this as is to sql and then manually delete.
0
shabeer shaik14y ago
i changed ('/')[0] to ('/')[1] and it works.

thanks again Vulpes
0
shabeer shaik14y ago
thanks Vulpes.

Only 1 problem. The label date is 12/15/2012 (which is 15 dec 2012)
i want to add the 15=6
This code adds 12 = 3
0
Vulpes14y ago
Try this:

string date = label1.Text.Split('/')[0];
textBox6.Text = AddDate(date).ToString();
0