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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Timesheet - Date Population

Avatar

Not applicable

Hey -
I am working on a semi-monthly timesheet form where the user will enter the period ending date. I'd like for the day of the month fields (1st, 2nd, etc) and the day of the week fields (M, T, W, etc) to auto-populate if possible. I am open to having the user enter both the period start date and period end date if necessary. I'm using Livecycle and most of the posts I've read regarding this are counting the number of days in between. The biggest issue I'm having is that the number of days in the pay period are different depending on the month. The PP ends the 1st and 16th. Any suggestions you have would be great - Thanks!

1 Reply

Avatar

Level 10

How about something like this?

The image, below, is a table where the first column is called 'date'. After you pick the date for row 0 (highlighted in yellow), the dates for the previous 7 days are calculated. The nice thing is that FormCalc takes care of calculating the dates correctly.

// form1.page1.subform1.table_.row_[0].date::exit - (FormCalc, client)

var dayNum = Date2Num($.formattedValue,"MM/DD/YYYY")

row_[1].date.rawValue = Num2Date(dayNum-1,"MM/DD/YYYY")

row_[2].date.rawValue = Num2Date(dayNum-2,"MM/DD/YYYY")

row_[3].date.rawValue = Num2Date(dayNum-3,"MM/DD/YYYY")

row_[4].date.rawValue = Num2Date(dayNum-4,"MM/DD/YYYY")

row_[5].date.rawValue = Num2Date(dayNum-5,"MM/DD/YYYY")

row_[6].date.rawValue = Num2Date(dayNum-6,"MM/DD/YYYY")

p.png

Steve