hi,
when you declare "dl" as date you will get the output like that only. to get the result as you want you have to declare "dl" as string.
for example,
dim dl as string
dl=format$(now(),"dd-MMM")
bye
Lavanya.
> Hi,
> I am trying to get today's date as in dd-mmm format. For this I have tried followings:
> dl = Format$(Now(), "d-MMM")
> dl = Format$(Now(), "dd-MMM")
> dl = Format$(Now, "dd-MMM")
> dl = Format$(Now, "d-MMM")
> here dl is a date variable.
> But dl is getting date as 11/1/2004.
> I want to get date as 01-Nov in dl variable. Please tell where am I wrong.
> Regards,
> Abhishek
|