Date Conversion Articles

Page 1 of 1 (4 articles)

5/3/2020 • EN

Converting Gnarly Date Strings to Proper Date Types Using a MongoDB Aggregation Pipeline

A technical guide on using MongoDB's aggregation pipeline to convert problematic date strings into proper Date types for better querying and indexing.

Aggregation Pipeline Data Import Date Conversion Datefromstring mongodb

Paul Done

4/9/2019 • EN

The Ultimate Opinionated Guide to Base R Date Format Functions

A guide to understanding and using R's date format functions like as.Date(), as.POSIXct(), strftime(), and strptime() for data manipulation.

Base R Date Conversion Date Manipulation R Strftime

Michael Toth

12/7/2011 • EN

Converting Excel Dates to UNIX Timestamps

A technical guide explaining the formula to convert Microsoft Excel date values into UNIX timestamp format.

Date Conversion Excel formula timestamp unix

Chris Bradshaw

10/10/2011 • EN

Converting UNIX Timestamps to Excel Dates

A guide on converting UNIX timestamps to readable Excel dates using a simple formula, useful for analyzing log file data.

data analysis Date Conversion Excel formula Unix Timestamp