When I format the date so that a field gets the value as year-month-day-hour-minute-second, I omly see the date-portion, the rest is filled with zeros.
I use:
strDT = Format(Date, "yyyymmddhhmmss")
I get '20140226000000'
What goes wrong, or how can I get the desired result?
hvebsr
5
Newbie Poster
Recommended Answers
Jump to PostHi hvebsr welcome to DaniWeb.
Probably means your date variable does not store hour,minute and second info.
All 2 Replies
ddanbe
2,724
Professional Procrastinator
Featured Poster
Hi hvebsr welcome to DaniWeb.
Probably means your date variable does not store hour,minute and second info.
hvebsr
5
Newbie Poster
Hello ddanbe,
I resolved it by using 'now' in stead of 'date'
Thanks.
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.