Date and Time Functions in Fusion

Question 1

What function allows you to change the format of a date and how is this typically written?

Answer 1

formatDate (date; format; [timezone])

Question 2

What is the main difference between parseDate and formatDate functions?

Answer 2

parseDate is used to turn a text value into a date value.
formatDate just changes the formate of a date value to another date value format.

Question 3

How is the function parseDate written out?

Answer 3

parseDate (text; format; [timezone])

Question 4

What function returns a new date as a result of adding a given number of days to a date, or can be used to subtract days by entering a negative number?

Answer 4

addDays (date; number)

Question 5

What function returns a new date as a result of adding a given number of hours to a date, or can be used to subtract hours by entering a negative number?

Answer 5

addHours (date; number)

Question 6

What function returns a new date as a result of adding a given number of minutes to a date, or can be used to subtract hours by entering a negative number?

Answer 6

addMinutes (date; number)

Question 7

What function returns a new date as a result of adding a given number of months to a date, or can be used to subtract hours by entering a negative number?

Answer 7

addMonths (date; number)

Question 8

What function returns a new date as a result of adding a given number of seconds to a date, or can be used to subtract hours by entering a negative number?

Answer 8

addSeconds (date; number)

Question 9

What function returns a new date as a result of adding a given number of years to a date, or can be used to subtract hours by entering a negative number?

Answer 9

addYears (date; number)

Question 10

What function returns a new date with the seconds specified in parameters? Usually a number from 0 to 59 is used.

Answer 10

setSecond (date; number)

Question 11

What function returns a new date with the minutes specified in parameters? Usually a number from 0 to 59 is used.

Answer 11

setMinute (date; number)

Question 12

What function returns a new date with the hours specified in parameters? Usually a number from 0 to 23 is used.

Answer 12

setHour (date; number)

Question 13

What function returns a new date with the hours specified in parameters? Usually, Sunday set as 1 and Saturday set as a 7 in this function.

Answer 13

setDay (date; number/name of the day in English)

Question 14

What function returns a new date with the day of the month specified in parameters? Usually a number from 1 to 31 is used.

Answer 14

setDate (date; number)

Question 15

What function returns a new date with the month specified in parameters? Usually a number from 1 to 12 is used.

Answer 15

setMonth (date; number/name of the month in English)

Question 16

What function returns a new date with the year specified in parameters?

Answer 16

setYear (date; number)

Question 17

What function returns a number representing the difference in the two dates, expressed in the specified unit?

Answer 17

dateDifference (Date1; Date2; Unit)

*Date2 is subtracted from Date1.

Question 18

If you need to calculate a date corresponding to n-th day of week in month (for example, first Tuesday, third Friday, and so on), what is the formula that can be used?

Answer 18

{{addDays(setDate(1.date; 1); 1.n * 7 -formatDate(addDays(setDate(1.date; 1); “-“ + 1.dow); “E”))}}

Question 19

What expression can be used to calculate days between dates?

Answer 19

{{round((2.value - 1.value) / 1000 / 60 / 60 / 24)}}

Question 20

What expression can be used to calculate the last day of the month?

Answer 20

{{addDays(setDate(now; 1); -1)}}

Question 21

What expression can be used to calculate the last millisecond of the previous month?

Answer 21

{{parseDate(parseDate(formatDate(now; “YYYYMM01”); “YYYYMMDD”; “UTC”) - 1; “x”)}}