|Related to : Start of Day and End of Day Process
|Specifying start and end day for week
Specifying start and end day for week
I have the following Query
trunc(to_date(&datethru) - to_Date(&datefrom)) < 8 THEN
WHEN ceil(months_between(&datethru ,
&datefrom)) < = 1 THEN Wk|| to_char(Interval, W)
ceil(months_between(&datethru , &datefrom)) < 4 THEN
ELSE Qtr|| to_char(Interval, Q)
|GMT timestamp of the start / end of a given day ::.|
Oh, Im going crazy! Im having fun with some GMT dates / timestamps.
And offsets. And ARRRGH!!! I think Ill start byting the corners of the
furniture in the room if I continue. Ive been struggling with this all
Basically heres my problem. For maximul flexibility I
record GMT timestamps in a database. At least I hope that this is what
the following lines do (I became paranoic):
|Determine start/end day for a week number
I am trying to avoid the creation of a lookup table where I know
I should be able to calculate this. I need to determine the start and
end date of a week number. I did find this post from 2002:
http://www.access-programmers.co.uk/...end+dates+week but it doesn't
seem to work.
What I am trying to do is show all projects that
were opened at the start of a week number. For example, week 2 is from
1/7/2008 and ends on 1/13/2008 (provided that your week starts in the
week that 1/1 occurs and that your week starts on Monday). I need
this start date so I can show all projects that started on or before
1/7/2008 and were in an open status.
If I can't calculate t
|Finding a start day and end day of a giving week
I have a report which formats a value for me but its not doing
quiet what I need it to.
This is its control source:
return for eg. 41
I need to return the Mondays and Fridays date
of week 41.
Is there another way I can change the weeks to work
either with financial years or annual years.
|need start day and end day calculation
I need to calculate a start date to a day
Lets say start date is 01-01-2012 corresponding to day
one of the year.
And end date is 10-03-2012 corresponding to day
70 of the year.
I need this calculation in a query where i have a
start date field and a end date field. we work with day numbers. so a
part with day number 10 has more priority than a part with a day
number of 14. how can i get this to work?
I used this from access
help =Format(Now(), "y")
But it gives me a error
Also keeps this formula into account February 29? (leap year)
would appreciate a sample so i can figure out how it works a
|Start of Day and End of Day Process
In my database i need two process in the database
one is SOD(Start of Day) and the 2nd one is EOD (End Of Day).
purpose of these process to run multiple hidden queries in back-end.
In both processes there are several queries to run.
I need help
to setup this.i have no idea that how i can built this but this is
necessary for database.
another thing these process execute only
once a day.
after login i want to run a form that will check
that SOD is performed or not if not then SOD (Run SOD) Screen will
appear if SOD not perform yet then system ask for SOD Process to run
otherwise disable my dashboard items.
and 2ndly if EOD not perfor