...

Date time combination

 

date() can combine multiple variables containing date information into a date variable

..

A

1

=create(year,month,day)

2

=A1.insert(100)

3

=A1.run(year=2021,month=rand(12),day=if([1,3,5,7,8,10,12].contain(month),rand(31),if(month==2,rand(28),rand(30))))

4

=A1.derive(date(year,month,day):derive_date)

A1-A3 Create a table containing the year, month, and day information, and randomly generate 100 data pieces

..

A4 Use the date() function to combine three variables into a date variable

..

Similarly, time() can combine multiple variables containing time information into a time variable

datetime() can combine multiple variables containing date-time information into a date-time variable


 
 •  103 View  •