Calculating months between two dates to then populate multiple text fields.
Hi all! I need help!
Ideally I want to be able to calculate the months between DOB and IFSPDate, into months (rounding down if between months (i.e. rounding to 11 if 11.5). I then want the selection of months to populate three different fields with a paragraph of information.
For example:
DOB: 12/01/2017
IFSPDate: 06/13/2019
The following fields would then populate:
CAMonths: 18
SocialSkillsCA: Snapshot of 18 month old children in this area: Children are using words more often to make requests, comments, protest/refuse, greet and respond to others while maintaining eye contact as they interact socially. Children are now often found playing near each other with similar toys. They may bite, hit, scratch or pull hair if overwhelmed and unable to express this frustration with words. Pushing limits, saying ‘no’ and tantrums are all part of children’s development at this age. They may express more complex emotions such as fear, sympathy, modesty, guilt and embarrassment through facial expression and body language more so than words. They can now predict that a broken toy will make another child unhappy. They may attempt to change the other child’s affect by offering a suitable toy.
AcquiringCA: Snapshot of 18 month old children in this area: Children’s play is expanding to include simple pretend play. They will experiment with an object to discover its purpose but no longer need to mouth it. Attention and interest in books increases and they will sit and listen to a shortened version of a story. When asked, they can point to pictures in books and can name familiar objects they see in pictures. During typical family routines like meals, playtime, dressing, etc., they will show they know the names of objects from a variety of categories (e.g., foods, clothes, toys, etc.). They say at least 15 different words that are functional and relate to daily routines, most likely the names of people and objects that are important to them.
BehaviorCA: Snapshot of 18 month old children in this area: Children are very active now- running, carrying larger toys while walking and walking up stairs with a hand held. They can climb up onto a chair and sit down. They actively participate in self-care activities- unzipping a zipper, working on undressing and feeding themselves with a spoon. At meals, they are eating the same foods as other family members. They are more cooperative with teeth brushing and more interested in household activities (imitating some simple activities likes cleaning up spills). Wants and needs are expressed to others with words and gestures during familiar daily routines.
If this is not possible, I at least want to be able to populate three text fields, with a drop down option of CAmonths. I have been successful using the custom vaildation script if 1 month or 2 months is selected, but after the text fields are blank but I am not getting an error in the script. PLEASE HELP!!!
