Convert the date to day of the week.
On Sun, 23 Mar 2008 05:14:00 -0700, Nils Titley
wrote:
Ron,
I confess, I don't know how to get the numeric value of it?
Perhaps this will help:
=====================================
Option Explicit
Sub foo()
Const dt As Date = #2/12/2008#
Const dt2 As Date = #12/2/2008#
Debug.Print CLng(dt), Format(dt, "dddd, dd-mmm-yyyy")
Debug.Print CLng(dt2), Format(dt2, "dddd, dd-mmm-yyyy")
End Sub
====================================
--ron
|