Long date without Day

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report in a letter format. It prints the date above the address. I
am using the date() function. It prints the Day before the Month Day, Year.
How do I print the Month Day, Year without printing the Day?

As always, thanks for your help.

Sarah
 
Hi Sarah,

format(Date(),"mmmm d, yyyy")
--> February 24, 2006

format(Date(),"mmm d, yyyy")
--> Feb 24, 2006

format(Date(),"ddd mmm d, yyyy")
--> Fri Feb 24, 2006

format(Date(),"m-d-yy")
--> 2-24-06

format(Date(),"mm/dd/yy")
--> 02/24/06

etc!


Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access
strive4peace2006 at yahoo.com
 
Just what I needed.

Thanks

Crystal said:
Hi Sarah,

format(Date(),"mmmm d, yyyy")
--> February 24, 2006

format(Date(),"mmm d, yyyy")
--> Feb 24, 2006

format(Date(),"ddd mmm d, yyyy")
--> Fri Feb 24, 2006

format(Date(),"m-d-yy")
--> 2-24-06

format(Date(),"mm/dd/yy")
--> 02/24/06

etc!


Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access
strive4peace2006 at yahoo.com
Click to expand...
 
you're welcome, Sarah ;) happy to help

Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access
strive4peace2006 at yahoo.com
 
Back
Top