what is the creiteria for month ending Format([Week Ending],"Shor

  • Thread starter Thread starter Frankie
  • Start date Start date
F

Frankie

Format([Week Ending],"Short Date") is the creiteria for week ending what is
it for month ending?
 
Format([Week Ending],"Short Date") is the creiteria for week ending what is
it for month ending?
Click to expand...

What's the context, Frankie? A Format() function translates a field in some
other datatype (date/time perhaps) to a Text string according to a suitable
display format. It's not a criterion, and it will not return a week ending or
a month ending. Your expression simply displays a Date/Time value stored in
the field named [Week Ending] - which could be ANY date, Access won't
interpret the fieldname! - according to the Windows regional date/time Short
Date format.

What's in your table, and what are you trying to accomplish?
 

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

If then 2
Help with generating week dates for a table. 2
sum weekly data into monthly 1
Sort Formatted Date 1
How to count records w/o counting duplicates by week, month, or ye 4
Querying Dates 5
Week ending date query help 1
Count Weeks Between Start and End Date 3

Back
Top