We have updated WebDataRocks EULA, effective as of April 18, 2024. Learn more about what's changed.

Date Weeks

Answered

Is it possible to split date fields into week numbers? We currently have Year, Month, Day, would be nice to have Week and Quarter also.
Thank you!

1 answer

WebDataRocks Team WebDataRocks March 31, 2020

Hello, Benoit,
 
Thank you for reaching out to us.
 
We would like to kindly inform, that it is possible to split the data into years, months, quarters, and days using the following JSON data type: year/quarter/month/day or D4+ CSV data type.
 
However, for now, it is not possible to split the dates into weeks.
 
More information about JSON data types in our documentation.
In case your data source is CSV, here is the page dedicated to data types in CSV.
 
We hope it helps.
Please contact us in case additional questions occur.
 
Best regards,
WebDataRocks Team