#Creates one record for each day of the current month
Set Variable [ $Today ; Value: Get ( CurrentDate ) ]
Set Variable [$Date ; value: $Today - Day ( $Today ) + 1 //computes date of first day of this month ]
Exit Loop If [$Date > Date ( Month ( $Today ) + 1 ; 0 ; Year ( $Today ) //computes date of last day of this month ]
Set Field [YourTable::DateField ; $Date ]
Set variable [$Date ; value: $Date + 1 ]
A variation of this can replace $Today with a global date field and then the script can generate these records for any month/year selected by the user when they select or enter any date from that month/year.
Thanks alot Phil and sorry for replying late,
1. I didn't get where I will add the script
2. How can I fix it to create a new record on 15th of every month.
Hello any update on this please