+ 14780) / 3652425), 0, Convert.indexOf(Convert.floatToString((10000*date_number1 + 14780) / 3652425), '.'))) Ĭonvert.stringToInt(Convert.subString(Convert.floatToString(yyyy1/4), 0, Convert.indexOf(Convert.floatToString(yyyy1/4), '.'))) -Ĭonvert.stringToInt(Convert.subString(Convert.floatToString(yyyy1/400), 0, Convert.indexOf(Convert.floatToString(yyyy1/400), '.')))) ĭdd = date_number1 - (365*yyyy1 + Convert.stringToInt(Convert.subString(Convert.floatToString(yyyy1/4), 0, Convert.indexOf(Convert.floatToString(yyyy1/4), '.'))) - Convert.stringToInt(Convert.subString(Convert.floatToString(yyyy1/100), 0, Convert.indexOf(Convert.floatToString(yyyy1/100), '.'))) +
Yyyy1 = Convert.stringToInt(Convert.subString(Convert.floatToString((10000*date_number1 Var date_number1 = 365*yyyy1 + Convert.stringToInt(Convert.subString(Convert.floatToString(yyyy1/4), 0, Convert.indexOf(Convert.floatToString(yyyy1/4), '.'))) -Ĭonvert.stringToInt(Convert.subString(Convert.floatToString(yyyy1/100), 0, Convert.indexOf(Convert.floatToString(yyyy1/100), '.'))) +Ĭonvert.stringToInt(Convert.subString(Convert.floatToString(yyyy1/400), 0, Convert.indexOf(Convert.floatToString(yyyy1/400), '.'))) +Ĭonvert.stringToInt(Convert.subString(Convert.floatToString((mm1*306+5) / 10), 0, Convert.indexOf(Convert.floatToString((mm1*306+5) / 10), '.'))) + (dd1-1) Yyyy1 = yyyy1 - Convert.stringToInt(Convert.subString(Convert.floatToString(mm1/10), 0, Convert.indexOf(Convert.floatToString(mm1/4), '.'))) Var dd1 = Convert.stringToInt(Convert.subString(dt1, 6, 8)) Var mm1 = Convert.stringToInt(Convert.subString(dt1, 4, 6)) Var yyyy1 = Convert.stringToInt(Convert.subString(dt1, 0, 4))
To change the format just modify the last but 1 line of the code given below.ĭesign Studio Code: var dt1 = pToDate.getDate()
Define a date field in design studio application.Steps used in the below particular scenario: The following script code will be useful in a scenario where you need to pass a date and a number of days to be added/subtracted and get the new date back. In short, date functions are not available Design Studio in today’s date. To add/subtract a number of days to/from today’s date there is no one line code that you can write. Design Studio doesn’t have the capacity to do any calculation with dates in the front end scripting.