Forum Discussion
a long time away: just expression builder help
Hey! I was standalone. began with the DOS5.0/WIN3.0,3.1 late December 1991, 3 mos later SDK on 5.25", $300.00 at the mall came with 4 feet of paperbacks, then 3.5" but left CE school because. La...
Thanks George Hepworth.
Suppose an ACCESS field 'DaysIWantToKnow' were a series of 500,000 days; these days began 250,000 days ago; another ACCESS field, 'DateCertain' could be a shortdate-type...so, how does one write an expression that will accomplish such a thing?
(b) another field might know what day of the week it was/is or will be?
JLS
500,000 days. 250,000 days before a specific Date? And 250,000 days after that date?
And DateCertain is what? What are you really doing here? Is this part of a real-world project, or are you just playing with dates?
The direct answer to the question is: WeekDay(YourDateGoeHere, vbSunday). That will return a number from 1 to 7, based on the first day of the week being Sunday. In other words, Weekday(#8/27/2023#,vbSunday) will return 1.
I have no idea how that might relate, though, to what you are trying to accomplish.
And DateCertain is what? What are you really doing here? Is this part of a real-world project, or are you just playing with dates?
The direct answer to the question is: WeekDay(YourDateGoeHere, vbSunday). That will return a number from 1 to 7, based on the first day of the week being Sunday. In other words, Weekday(#8/27/2023#,vbSunday) will return 1.
I have no idea how that might relate, though, to what you are trying to accomplish.
- Never mind, I'll do it myself.