how to make "12/02/2016 6:00" as "12/02 6:00" thanks! ;)

[ben1988]

how to make "12/02/2016 6:00" as "12/02 6:00" thanks! ;)

[zmbd]

Format Function (syntax)

Format(#12/02/2016 06:00#,"MM/DD h:nn")

Keep in mind the "#MM/DD/YYYY hh:nn#" USA date format is used by Access for VBA functions and take note of the "#" literals

If you pass a variable to the function defined as a date (ether as a field in a table, or via the DIM x As Date the literals are not usually required (ACC will still require the MM/DD/YY hh:nn format); however, a string value will need to include the literals.

[ben1988]

thanks but if i in vba
and now got date variable from function- suppose "startdate"
how i do/write the format function?
thanks

[zmbd]

Providing the section of code for this would be helpful.

Personally what I would do is something like:

(...air code...)
Dim zFoundDate as Date
Dim zString as String
(...)
zFoundDate = functiontofindthedate(withrequireddata)
zString = format(zFoundDate,"MM/DD hh:mm")
(...)