monday Formulas - Part 3: Dates/Times, Strings and Status скачать в хорошем качестве

monday Formulas - Part 3: Dates/Times, Strings and Status

This is part 3 of our series about monday.com formulas. In this video I will introduce you to the "fake status" and describe string functions with a detailed example then go through what you need to know to use the date and time functions. ⏱Outline/Time Stamps 00:00 Intro 01:25 Fake Status Columns 04:22 Date and Time Functions 07:54 String Functions 14:36 -- Detailed String Example ** Date Formatting Codes ** Code Result d Day of the week as 0-6 (Sun = 0) do Day of the week as 1st, 2nd, 3rd, etc. dd Day of the week as Su-Sa ddd Day of the week as Sun-Sat dddd Day of the week as Sunday-Saturday D Days of the month as 1–31 Do Day of the month as 1st, 2nd, 3rd, etc. DD Days of the month as 01–31 DDD Day of the Year DDDo Day of the Year as 1st, 2nd, 3rd, etc. E Day of the week as 1-7 (Sun = 7) L Date in MM/DD/YYYY M Months as 1–12 Mo Month as 1st, 2nd, 3rd, etc. MM Months as 01–12 MMM Months as Jan–Dec MMMM Months as January–December Q Quarter Qo Quarter as 1st, 2nd, 3rd, 4th W Week of the year as 1-53 Wo Week of the year as 1st, 2nd, etc. WW Week of the year as 01-53 Y Year as 1900–9999 YY Years as 00–99 YYYY Years as 1900–9999 ** Time Formatting Codes ** Code Result s Seconds as 1–59 ss Seconds as 01–59 SSS Thousandths ??? m Minutes as 1–59 mm Minutes as 01–59 h Hours as 1–12 hh Hours as 01–12 H Hours as 1–23 HH Hours as 01–23 a am/pm A AM/PM Monday Man Links Create Make account: https://www.make.com/en/register?pc=t... Get in Contact: https://themondayman.com/contact/ Hire The Monday Man: https://themondayman.com/custom/ #mondaydotcom #formulas