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?

Hi hvebsr welcome to DaniWeb.
Probably means your date variable does not store hour,minute and second info.

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.