Adding Days of the Week

-

good morning all,

 

i creating timesheet. in timesheet, have date field named "ppsd1". have made table days in pay period. in table, there fields days of week. have inserted below code, takes date enter "ppsd1" , calculates day of week, inserting field named "day1".

 

num2date(date2num(ppsd1.formattedvalue

, "mm/dd/yyyy"), "eeee")

 

what need do, have calculate remaining days of week automatically based on first entry.

 

for example, if enter 06/01/2010 "ppsd1", returns "tuesday" "day1". need put "wednesday" "day2"; "thursday" "day3", etc.

 

any , appreciated.

 

gene-o

hi,

 

here sample uses pattern date{eeee} show day of week. https://acrobat.com/#d=9y7jktrm3uwmtnpoifudsg

 

formcalc best working dates, see num2date , date2num functions used in calculate event.

 

hope helps,

 

niall



More discussions in LiveCycle Designer


adobe

Comments

Post a Comment

Popular posts from this blog

CS5 Adobe Media Encoder: Encode failed because the source duration is nil.

-
i've been running production premium on new windows 7 64bit, 6gb i7 system several weeks , haven't had issues exporting media encoder.   i installed trial version of dreamweaver without of add-on's thought might mess licensed installation.   every attempt export -> media -> queue get's following error in ameencodingerrorlog.txt   - source file: c:\users\rob\appdata\local\temp\someproject.prproj - output file: c:\users\rob\videos\someproject.mov - preset used: custom - video: - audio: - bitrate: - encoding time: 00:00:00 7/8/2010 10:14:34 : encoding failed ------------------------------------------------- encode failed because source duration nil.   doing export directly pp works without error, don't want wait each export complete.   any ideas other reinstall pp?   tia i noticed range selector triangles right next each other.   changed source range: work area   not sure why default set 0 range. doesn't remember last setting when selected entire sequ
Read more

cf_sql_integer vs cf_sql_bigint vs cf_sql_int??

-
i have id (primary key) set bigint in sql server. have query following: where whateverid = <cfqueryparam cfsqltype="cf_sql_integer" value="#url.id#"> i got invalid data type it. tried: where whateverid = <cfqueryparam cfsqltype="cf_sql_bigint" value="#url.id#"> i still got invalid data type it. tried: where whateverid = <cfqueryparam cfsqltype="cf_sql_int" value="#url.id#"> and worked. the weird thing cf_sql_int not listed being accepted: http://www.adobe.com/livedocs/coldfusion/5.0/cfml_reference/tags79.htm can explain me. > whateverid = <cfqueryparam cfsqltype="cf_sql_bigint" value="#url.id#"> what value of #url.id#? had no problems either using cf8. > weird thing cf_sql_int not listed being accepted: iirc, when pass in invalid sql type cf uses default: cf_sql_char, accepts anything. ms sql implicit convert() right type , why works. More discussions in Data
Read more

localhost/joomla15/administrator doesnt work - Joomla! Forum - community, help and support

-
hi, i'm starting , address http://localhost/joomla15/administrator doesn't work (it stays blank, no error or anything). wonder if have change in address or somewhere else. joomla installed through web-host dreamhost.com , didn't have much. i appreciate help. silvia http://localhost tells browser not go out internet use localized web server installed on pc. lack of better description, localized web server doing coding , test site development on local pc using software turns pc "local" web server; hence, term - localhost. you mentioned dreamhost.com installing joomla. assume mean installed joomla on hosting account? so need access joomla installation by: http://www.yourdomain.com/joomla15/administrator Board index Joomla! Older Version Support Joomla! 1.5 Installation 1.5
Read more