Adobe LiveCycle (Archived)

TTreib · 9/10/12

I am building a monthly time sheet. I need all the dates to populate once the initial date is chosen by the user. I have this working properly for each month that has 31 days. For months with 30 days, it populates the first day of the next month. How do I make sure that the only the dates for the month selected are populated?

Any help is appreciated!

Tracy

radzmar · 9/11/12

Ok,

here's a modifiedversion of your form.

It uses a dynamic table, which has sevaral benefits like very slim calculation scripts and a small file size.

https://acrobat.com/#d=gTlaptez8XA2A5*0it4Wow

View solution in original post

radzmar · 9/10/12

Hi,

you need a script to determine the number of days in the current month.

This can be done with FormCalc.

Here an example. Assuming you have two datefields and one text field to display the number of days.

Put this script into the calculate event of the text field.

When the user selects a any date in DateField1 the script determines the first and last day in the current month and will display the related dates in the date fields.

var StartDate = Ref(DateField1)
var EndDate = Ref(DateField2)
  
var MonthStart = Date2Num(StartDate.formattedValue, "DD.MM.YYYY")
var nDay = Num2Date(MonthStart, "DD")                                                  ; Current Day
var nMonth = Num2Date(MonthStart, "MM")                                        ; Current Month
var nYear = Num2Date(MonthStart, "YYYY")                                        ; Current Year
var nFirstDay = Date2Num(Concat("01.",nMonth, ".", nYear), "DD.MM.YYYY")                    ; First Day in the curren month
var nLastDay
var nCountDays = nFirstDay
StartDate.rawValue = Num2Date(nFirstDay, "DD.MM.YYYY") ; Set first day of month as start date
  
; Determine number of days in the current month
var nMonthCheckStart = Num2Date(nFirstDay, "MM")
var nMonthCheckEnd
for i=0 upto 31 step 1 do
          nCountDays = nCountDays + 1
          nMonthCheckEnd = Num2Date(nCountDays , "MM")
          if(nMonthCheckStart == nMonthCheckEnd) then
                    nLastDay = nCountDays 
          endif
endfor
  
EndDate.rawValue = Num2Date(nLastDay, "DD.MM.YYYY") ; Set lastday of month as end date
$.rawValue = Num2Date(nLastDay, "DD") ; Set number of days this month

TTreib · 9/11/12

Hello!

Thank you for your response, but I can not get it to function properly.

I added a text field to calculate the number of days. Here is the script I placed in the text field:

 form1.commentSub.NoofDays::calculate - (FormCalc, client)
var StartDate = Ref(SubPg1.tableSub.Table1.Row1.Date1)
var EndDate = Ref(SubPg1.tableSub.Table1.Row2.Date2)
var MonthStart = Date2Num(Date1.formattedValue, "MM/DD/YYYY")
var nMonth = Num2Date(MonthStart, "MM")                                                                                                     ; Current Month
var nDay = Num2Date(MonthStart, "DD")                                           ; Current Day
var nYear = Num2Date(MonthStart, "YYYY")                                        ; Current Year
var nFirstDay = Date2Num(Concat(nMonth,"01", nYear), "MM/DD/YYYY")        ; First Day in the current month
var nLastDay
var nCountDays = nFirstDay
StartDate.rawValue = Num2Date(nFirstDay, "MM/DD/YYYY") ; Set first day of month as start date
; Determine number of days in the current month
var nMonthCheckStart = Num2Date(nFirstDay, "MM")
var nMonthCheckEnd
for i=0 upto 31 step 1 do
          nCountDays = nCountDays + 1
          nMonthCheckEnd = Num2Date(nCountDays , "MM")
          if(nMonthCheckStart == nMonthCheckEnd) then
                    nLastDay = nCountDays 
          endif
endfor
EndDate.rawValue = Num2Date(nLastDay, "MM/DD/YYYY") ; Set lastday of month as end date
$.rawValue = Num2Date(nLastDay, "DD") ; Set number of days this month

In the date field where the user selects the date. I have this:

form1.SubPg1.tableSub.Table1.Row1.Date1::exit - (FormCalc, client)
var dayNum = Date2Num($.formattedValue,"MM/DD/YY")
Row2.Date2.rawValue = Num2Date(dayNum+1,"MM/DD/YY")
Row3.Date3.rawValue = Num2Date(dayNum+2,"MM/DD/YY")
Row4.Date4.rawValue = Num2Date(dayNum+3,"MM/DD/YY")
Row5.Date5.rawValue = Num2Date(dayNum+4,"MM/DD/YY")
Row6.Date6.rawValue = Num2Date(dayNum+5,"MM/DD/YY")
Row7.Date7.rawValue = Num2Date(dayNum+6,"MM/DD/YY")
Row8.Date8.rawValue = Num2Date(dayNum+7,"MM/DD/YY")
Row9.Date9.rawValue = Num2Date(dayNum+8,"MM/DD/YY")
Row10.Date10.rawValue = Num2Date(dayNum+9,"MM/DD/YY")
Row11.Date11.rawValue = Num2Date(dayNum+10,"MM/DD/YY")
Row12.Date12.rawValue = Num2Date(dayNum+11,"MM/DD/YY")
Row13.Date13.rawValue = Num2Date(dayNum+12,"MM/DD/YY")
Row14.Date14.rawValue = Num2Date(dayNum+13,"MM/DD/YY")
Row15.Date15.rawValue = Num2Date(dayNum+14,"MM/DD/YY")
Row16.Date16.rawValue = Num2Date(dayNum+15,"MM/DD/YY")
Row17.Date17.rawValue = Num2Date(dayNum+16,"MM/DD/YY")
Row18.Date18.rawValue = Num2Date(dayNum+17,"MM/DD/YY")
Row19.Date19.rawValue = Num2Date(dayNum+18,"MM/DD/YY")
Row20.Date20.rawValue = Num2Date(dayNum+19,"MM/DD/YY")
Row21.Date21.rawValue = Num2Date(dayNum+20,"MM/DD/YY")
Row22.Date22.rawValue = Num2Date(dayNum+21,"MM/DD/YY")
Row23.Date23.rawValue = Num2Date(dayNum+22,"MM/DD/YY")
Row24.Date24.rawValue = Num2Date(dayNum+23,"MM/DD/YY")
Row25.Date25.rawValue = Num2Date(dayNum+24,"MM/DD/YY")
Row26.Date26.rawValue = Num2Date(dayNum+25,"MM/DD/YY")
Row27.Date27.rawValue = Num2Date(dayNum+26,"MM/DD/YY")
Row28.Date28.rawValue = Num2Date(dayNum+27,"MM/DD/YY")
Row29.Date29.rawValue = Num2Date(dayNum+28,"MM/DD/YY")
Row30.Date30.rawValue = Num2Date(dayNum+29,"MM/DD/YY")
Row31.Date31.rawValue = Num2Date(dayNum+30,"MM/DD/YY")
Row1.Day1.rawValue = Num2Date(dayNum,"EEE")
Row2.Day2.rawValue = Num2Date(dayNum+1,"EEE")
Row3.Day3.rawValue = Num2Date(dayNum+2,"EEE")
Row4.Day4.rawValue = Num2Date(dayNum+3,"EEE")
Row5.Day5.rawValue = Num2Date(dayNum+4,"EEE")
Row6.Day6.rawValue = Num2Date(dayNum+5,"EEE")
Row7.Day7.rawValue = Num2Date(dayNum+6,"EEE")
Row8.Day8.rawValue = Num2Date(dayNum+7,"EEE")
Row9.Day9.rawValue = Num2Date(dayNum+8,"EEE")
Row10.Day10.rawValue = Num2Date(dayNum+9,"EEE")
Row11.Day11.rawValue = Num2Date(dayNum+10,"EEE")
Row12.Day12.rawValue = Num2Date(dayNum+11,"EEE")
Row13.Day13.rawValue = Num2Date(dayNum+12,"EEE")
Row14.Day14.rawValue = Num2Date(dayNum+13,"EEE")
Row15.Day15.rawValue = Num2Date(dayNum+14,"EEE")
Row16.Day16.rawValue = Num2Date(dayNum+15,"EEE")
Row17.Day17.rawValue = Num2Date(dayNum+16,"EEE")
Row18.Day18.rawValue = Num2Date(dayNum+17,"EEE")
Row19.Day19.rawValue = Num2Date(dayNum+18,"EEE")
Row20.Day20.rawValue = Num2Date(dayNum+19,"EEE")
Row21.Day21.rawValue = Num2Date(dayNum+20,"EEE")
Row22.Day22.rawValue = Num2Date(dayNum+21,"EEE")
Row23.Day23.rawValue = Num2Date(dayNum+22,"EEE")
Row24.Day24.rawValue = Num2Date(dayNum+23,"EEE")
Row25.Day25.rawValue = Num2Date(dayNum+24,"EEE")
Row26.Day26.rawValue = Num2Date(dayNum+25,"EEE")
Row27.Day27.rawValue = Num2Date(dayNum+26,"EEE")
Row28.Day28.rawValue = Num2Date(dayNum+27,"EEE")
Row29.Day29.rawValue = Num2Date(dayNum+28,"EEE")
Row30.Day30.rawValue = Num2Date(dayNum+29,"EEE")
Row31.Day31.rawValue = Num2Date(dayNum+30,"EEE")

It still adds the beginning date for the following month if the month selected only has 30 days.

I am not sure how to attach the file here for you to see.

Tracy

radzmar · 9/11/12

Hi,

your solution seems to be complicated, as you need to write a script for every single row.

I made an example for you that uses a dynamic table.

https://acrobat.com/#d=192ZhzEbnF9o9yx7ixE*Hw

TTreib · 9/11/12

There are 17 fields on each row that need scripting for time worked and leave taken. It is quite a complicated two page form that is required to be in a specific format. Could I email the form so you may have a look?

Tracy

radzmar · 9/11/12

Upload the form to Acrobat.com and share the link here.

TTreib · 9/11/12

Thank you so much. This is the most difficult form I have ever done.

Tracy

https://acrobat.com/#d=MkIVhWQNjAX0Mha-LZGZKg

radzmar · 9/11/12

Hi,

please check that you shared the form, I got no access.

TTreib · 9/11/12

Try this. I am new to the forums. I apologize for my inexperience. I did not publish the form first.

Thank You!

https://acrobat.com/#d=MkIVhWQNjAX0Mha-LZGZKg

radzmar · 9/11/12

Ok,

here's a modifiedversion of your form.

It uses a dynamic table, which has sevaral benefits like very slim calculation scripts and a small file size.

https://acrobat.com/#d=gTlaptez8XA2A5*0it4Wow

TTreib · 9/11/12

It is exactly what I need. Now I know how ro accomplish this. Thank you so much! You are the BEST!!!

Tracy

TTreib · 9/17/12

I have one more question.

I have reader enabled the form. Upon a user completeing the form, none of the information input by the user into the time table will save. The header information is saved and all page 2 information is saved, but nothing will save in table1.

Any suggestions?

Tracy

sandrab53419774 · 3/26/19

I need it for a month Employee name, log in time for arrival and depart, time log for lunch Time for daily activity log in and out, comments and log time for Vacation, sick leave, personal leave holiday

Adobe LiveCycle (Archived)

Monthly Time Sheet Dates

Learn

Documentation

Community

Support

Resources

Adobe account

Adobe