Query expression...

  • Thread starter Thread starter 116
  • Start date Start date
1

116

I am currently using 'Weekday: DatePart("w",[Wdate])'. Can the actual day
Mon, Tues, etc. be displayed?
 
hi,

I am currently using 'Weekday: DatePart("w",[Wdate])'. Can the actual day
Mon, Tues, etc. be displayed?
Click to expand...
Use Format():

Format(Now(), "ddd") or Format(Now(), "dddd")


mfG
--> stefan <--
 
â€â€ÙƒØªØ¨ "Stefan Hoffmann said:
hi,

I am currently using 'Weekday: DatePart("w",[Wdate])'. Can the actual
day
Mon, Tues, etc. be displayed?
Click to expand...
Use Format():

Format(Now(), "ddd") or Format(Now(), "dddd")


mfG
--> stefan <--
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Join on derived table 2
Sorting day names chronologically 5
Problems with Date Add & summation of values 3
Type Mismatch error 1
DatePart function 2
Update by most recent date 2
Next weekday ... 3
Week Number 2

Back
Top