Whatsapp Icon Whatsapp Icon Facebook Google+ Linkedin Twitter

ReplyRe: Date Formatting From:
Lavanya

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

This message is a Reply to: Date Formatting from Abhishek Saxena

Replies to this message:
-None-

 Logo of Edelweiss   Mahindra Logo   Logo of IDBI   Himalayan Logo   ICICI Foundation Logo   Camlin Kokuyo Logo   Logo of Okaya   Microtek Logo   Logo of Action Tesa   Wonderchef company Logo   Vichare Express & Logistics Pvt Ltd Logo   Logo of Bonanza Bullion Private Limited   Globetech Logo   Mascot Universal Logo   Logo of Connell Bros   GDA Trusteeship Ltd Logo   Asian Logo   ROGER Car Techssories Logo   Elite International Logo   Charminar Logo   Logo of Brave   Goldmedal Logo   Logo of Slider Bearings   National College Logo   Mafatlal Logo   Krishgen Logo
 Logo of Edelweiss   Mahindra Logo   Logo of IDBI   Himalayan Logo   ICICI Foundation Logo   Camlin Kokuyo Logo   Logo of Okaya   Microtek Logo   Logo of Action Tesa   Wonderchef company Logo   Vichare Express & Logistics Pvt Ltd Logo   Logo of Bonanza Bullion Private Limited   Globetech Logo   Mascot Universal Logo   Logo of Connell Bros   GDA Trusteeship Ltd Logo   Asian Logo   ROGER Car Techssories Logo   Elite International Logo   Charminar Logo   Logo of Brave   Goldmedal Logo   Logo of Slider Bearings   National College Logo   Mafatlal Logo   Krishgen Logo
E-mail : sales@virtualsplat.com
Phone : +91-9892413501

Whatsapp Icon +91-9967648641

Whatsapp Icon +91-9967648641