Copy of 14thFeb_Testing!!!!!!!!!
Share
Explore
Copy of 14thFeb_Testing!!!!!!!!!

Created(object)

Copy link
Returns the datetime for when the provided item was created.
INPUTS
objectA Coda object. This includes tables, views, columns, rows, sections, and docs.
ExampleTable.Created()
⟶ 3/8/2017 9:23:18 AM

⁠
/d/14thFeb-Testing_dlVzLBLLj7z/
⁠
Date(year, month, day)

Copy link
Returns a date for the provided year, month, and day.
Date(1985, 1, 4)
⟶ 1/4/1985
Date(1776, 7, 4)
⟶ 7/4/1776

⁠
/d/14thFeb-Testing_dlVzLBLLj7z/
⁠
DateTimeTruncate(date, interval)

Copy link
Truncates the provided datetime by the specified interval (year, quarter, month, day, hour, minute or second).
INPUTS
dateA Date, Time, or DateTime value.interval
Time(1, 30, 45).DateTimeTruncate("minute")
⟶ 1:30 AM
Time(1, 30, 45).DateTimeTruncate("hour")
⟶ 1:00 AM

⁠
/d/14thFeb-Testing_dlVzLBLLj7z/
⁠
Day(date)

Copy link
Returns the day of the given date.
INPUTS
dateA Date, Time, or DateTime value.
Day(Date(2013, 4, 18))
⟶ 18

⁠
/d/14thFeb-Testing_dlVzLBLLj7z/
⁠
EndOfMonth(date, months)

Copy link
Returns the date for the last day of the month of a date plus the given number of months before or after.
INPUTS
dateA Date, Time, or DateTime value.months
EndOfMonth(Today(), 3)
⟶ 6/30/2017
EndOfMonth(Date(2017, 03, 20), 1)
⟶ 4/30/2017

⁠
/d/14thFeb-Testing_dlVzLBLLj7z/
⁠
EpochToDate(timestamp)

Copy link
Converts the provided epoch value to a datetime.
EpochToDate(1489187664)
⟶ 3/10/2017 3:14:24 PM

⁠
/d/14thFeb-Testing_dlVzLBLLj7z/
⁠
Hour(date)

Copy link
Returns the hour of the given datetime.
INPUTS
dateA Date, Time, or DateTime value.
Hour(Time(1, 30, 45))
⟶ 1

⁠
/d/14thFeb-Testing_dlVzLBLLj7z/
⁠
Minute(date)

Copy link
Returns the minute of the given datetime.
INPUTS
dateA Date, Time, or DateTime value.
Minute(Time(1, 30, 45)
⟶ 30

⁠
/d/14thFeb-Testing_dlVzLBLLj7z/
⁠
Modified(object)

Copy link
Returns the datetime representing the last time the given item was updated.
INPUTS
objectA Coda object. This includes tables, views, columns, rows, sections, and docs.
Table.Modified()
⟶ 3/10/2017 8:56:23 AM

⁠
/d/14thFeb-Testing_dlVzLBLLj7z/
⁠
Month(date)

Copy link
Returns the month of the given date.
INPUTS
dateA Date, Time, or DateTime value.
Month(Date(2013, 4, 18))
⟶ 4

⁠
/d/14thFeb-Testing_dlVzLBLLj7z/
⁠
MonthName(date, format)

Copy link
Returns the name of the month for the given date.
INPUTS
dateA Date, Time, or DateTime value.formatOptional. "MMM" or "MMMM".
MonthName(Date(2013, 4, 18))
⟶ April

⁠
/d/14thFeb-Testing_dlVzLBLLj7z/
⁠
NetWorkingDays(startdate, enddate, holidays)

Copy link
Returns the number of net working days (M-F) between two provided dates.
INPUTS
startdateThe start date to calculate the number of net working days.enddateThe end date to calculate the number of net working days.holidaysOptional. A list of dates to exclude as working days (e.g. holidays).
NetWorkingDays(Date(2016, 2, 1), Date(2016, 2, 3))
⟶ 3

⁠
/d/14thFeb-Testing_dlVzLBLLj7z/
⁠
Now()

Copy link
Returns the current date and time.
Now()
⟶ 3/10/2017 8:56:23 AM

⁠
/d/14thFeb-Testing_dlVzLBLLj7z/
⁠
RelativeDate(date, months)

Copy link
Returns a date a specified number of months before or after another date.
INPUTS
dateA Date, Time, or DateTime value.months
RelativeDate(Date(2016, 1, 1), 2)
⟶ 3/1/2016

⁠
/d/14thFeb-Testing_dlVzLBLLj7z/
⁠
Second(date)

Copy link
Returns the seconds of the given datetime.
INPUTS
dateA Date, Time, or DateTime value.
Second(Time(1, 30, 45))
⟶ 45

⁠
/d/14thFeb-Testing_dlVzLBLLj7z/
⁠
Time(hour, minute, second)

Copy link
Returns a time for the provided hour, minute, and second.
Time(1, 30, 45)
⟶ 1:30:45 AM
Time(17, 0, 0)
⟶ 5:00 PM

⁠
/d/14thFeb-Testing_dlVzLBLLj7z/
⁠
TimeValue(time)

Copy link
Returns the decimal number of the time represented by the provided text string.
TimeValue("5:30:18 PM")
⟶ 0.729375

⁠
/d/14thFeb-Testing_dlVzLBLLj7z/
⁠
ToDate(date)

Copy link
Converts the provided text into a date.
ToDate("2013-03-14")
⟶ 3/14/2013

⁠
/d/14thFeb-Testing_dlVzLBLLj7z/
⁠
ToDateTime(datetime)

Copy link
Converts the provided text into a datetime.
ToDateTime("2013-03-14 18:13:23")
⟶ 3/14/2013 6:13:23 PM

⁠
/d/14thFeb-Testing_dlVzLBLLj7z/
⁠
Today()

Copy link
Returns the current date.
Today()
⟶ 3/8/2017
Today() + Days(14)
⟶ 3/22/2017

⁠
/d/14thFeb-Testing_dlVzLBLLj7z/
⁠
WeekNumber(date, returnType)

Copy link
Returns the week number in the year for the given date.
INPUTS
dateA Date, Time, or DateTime value.returnTypeOptional.
WeekNumber(Date(1776, 7, 4))
⟶ 27

⁠
/d/14thFeb-Testing_dlVzLBLLj7z/
⁠
Weekday(date, returnType)

Copy link
Returns the day of week for the given date.
INPUTS
dateA Date, Time, or DateTime value.returnTypeOptional.
Weekday(Date(1776, 7, 4))
⟶ 5

⁠
/d/14thFeb-Testing_dlVzLBLLj7z/
⁠
WeekdayName(date)

Copy link
Returns the name of the day for the given date.
INPUTS
dateA Date, Time, or DateTime value.
WeekdayName(Date(1776, 7, 4))
⟶ Thursday

⁠
/d/14thFeb-Testing_dlVzLBLLj7z/
⁠
Workday(startdate, numDays, holidays)

Copy link
Returns the date after a specified number of working days (M-F) after the start date.
INPUTS
startdateThe date from which to begin counting.numDaysThe number of working days to advance from start_date. If negative, counts backwards.holidaysOptional. A range or array constant containing the dates to consider holidays.
Workday(Date(2016, 2, 1), 5)
⟶ 2/8/2016

⁠
/d/14thFeb-Testing_dlVzLBLLj7z/
⁠
Year(date)

Copy link
Returns the year component of the given date.
INPUTS
dateA Date, Time, or DateTime value.
Year(Date(1776, 7, 4))
⟶ 1776

Duration

⁠
/d/14thFeb-Testing_dlVzLBLLj7z/
⁠
Days(days)

Copy link
Returns a duration for the given number of days.
INPUTS
daysThe number of days
Days(14)
⟶ 14 days
Date(1776, 7, 4) + Days(7)
⟶ 7/11/1776

⁠
/d/14thFeb-Testing_dlVzLBLLj7z/
⁠
Duration(days, hours, minutes, seconds)

Copy link
Returns a duration for the provided days, hours, minutes, and seconds.
INPUTS
daysOptional. The number of dayshoursOptional. The number of hoursminutesOptional. The number of minutessecondsOptional. The number of seconds
Duration(4, 3, 2, 1)
⟶ 4 days 3 hrs 2 mins 1 sec

⁠
/d/14thFeb-Testing_dlVzLBLLj7z/
⁠
Hours(hours)

Copy link
Returns the duration for the given number of hours.
INPUTS
hoursThe number of hours
Hours(12)
⟶ 12 hrs
Hours(36)
⟶ 1 day 12 hours

⁠
/d/14thFeb-Testing_dlVzLBLLj7z/
⁠
Minutes(minutes)

Copy link
Returns a duration for the given number of minutes.
INPUTS
minutesThe number of minutes
Gallery
Share
 
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.