Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Adding Days of the Week

Avatar

Avatar
Validate 10
Level 2
Gene--O
Level 2

Likes

3 likes

Total Posts

76 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 3
Boost 1
View profile

Avatar
Validate 10
Level 2
Gene--O
Level 2

Likes

3 likes

Total Posts

76 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 3
Boost 1
View profile
Gene--O
Level 2

29-06-2010

Good Morning All,

I am creating a timesheet. In this timesheet, I have a date field named "PPSD1". I have made a table for the days in this pay period. In this table, there are fields for the days of the week. I have inserted the below code, which takes the date I enter into "PPSD1" and calculates the day of the week, inserting it into a field named "Day1".

Num2Date(Date2Num(PPSD1.formattedValue

, "MM/DD/YYYY"), "EEEE")

What I need to do, is have it calculate the remaining days of the week automatically based on this first entry.

For example, if I enter 06/01/2010 into "PPSD1", then it returns "Tuesday" into "Day1". I need it to put "Wednesday" into "Day2"; "Thursday" into "Day3", etc.

Any and all help is GREATLY appreciated.

Gene-O

View Entire Topic

Avatar

Avatar
Validate 10
Level 2
Gene--O
Level 2

Likes

3 likes

Total Posts

76 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 3
Boost 1
View profile

Avatar
Validate 10
Level 2
Gene--O
Level 2

Likes

3 likes

Total Posts

76 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 3
Boost 1
View profile
Gene--O
Level 2

30-06-2010

Thank's very much!!!

You guys are awesome!

Gene-O