Dates and Times in PandasOften the best way to learn something is to just jump in and try it out. Go ahead […] October 14, 2023 in Python tagged month / date / time / datetime by Mike
Create a Duration Column in PandasAre you working with a pandas dataset that has two datetime columns and you want to know the […] October 12, 2023 in Python tagged date / time / duration / pandas / difference by Mike
EDA Discovering with PandasExploratory Data Analysis has six phases: discovering, structuring, cleaning, joining, validating and presenting. The first phase is discovery. […] July 4, 2023 in Python tagged string / discovering / date / columns / python / plot / subset / pandas / random / EDA / sample / discovery / replace / Pandas EDA Discovery by Mike
Convert a String to a Date in RIn R language, if you have a string that you need to convert to a date, try this. […] March 28, 2023 in R Language tagged strings / convert / string / date by Mike
Dates in RDates are represented as the number of days since 1970-01-01, with negative values for earlier dates. Time What […] March 26, 2023 in R Language tagged dates / R / date by Mike
Excel Date and TimeAll dates in Excel has an associated date value, which is how Excel calculates the passage of time […] December 4, 2022 in Excel tagged date / time by Mike
Excel Pivot Tables Date GroupingDates can be a bit tricky. For the best solution to working with dates in our Pivot Table […] November 5, 2022 in Excel tagged group / dates / power / data / ungroup / table / client / date / tools / model / pivot / hide / calendar by Mike
WPF CalendarWPF has a nice built-in Calendar that looks like the one in Windows. It works along with the […] April 18, 2020 in WPF tagged calendar / datepicker / dates / date by Mike
C# TimeSpanTimeSpan represents a length of time, rather than an exact moment in time. The most simple way to […] January 1, 2019 in C# tagged properties / date / time / datetime / span / timespan / duration / C# Complex Types by Mike
C# Date and TimeThere is a type called DateTime that is defined in the System namespace that represents an exact moment […] January 1, 2019 in C# tagged format / C# / date / time / datetime / sqlite / OA / C# Complex Types by Mike
SQL Server DatetimeThe topic of date and time in SQL Server requires more attention than any of the other data […] April 6, 2017 in SQL Server tagged datetime / data / function / date / time by Mike
SQL Server Date Conversion FunctionHere we have a couple of code examples that work with dates. The first one gets today’s date […] February 7, 2017 in SQL Server tagged function / sql / date / Julian by Mike