Query expression...

1

116

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

Stefan Hoffmann

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 <--
 
G

Guest

â€â€ÙƒØªØ¨ "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...
 

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
DatePart in Filter By Form field 0
Next weekday ... 3
DatePart Expression 1
DatePart function 2
option group check boxes and tables? 2
Type Mismatch error 1
Week Number 2

Top