I have a datepicker on my form that I need to use as an integer value in the form yyyymmyy in an sql procedure. Can anyone tell me how to extract the datepicker value to an integer variable? Thanks
MJV
0
Junior Poster in Training
Recommended Answers
Jump to PostYYYY*10000 + MM*100 + YYYY % 100 should do the tric.
YYYY being DateTimePicker.Value.year and MM being DateTimePicker.Value.month of course.
All 3 Replies
ddanbe
2,724
Professional Procrastinator
Featured Poster
serkan sendur
821
Postaholic
Banned
serkan sendur
821
Postaholic
Banned
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.