How to return current date and not time
abalo006
Registered Posts: 29 ✭
data set full of jobs and each job has a start date, so I want to create a formula that says filter out my data where my start date hasn't happened yet / less than the current date.
The issue I'm having is when I create my now() function it gives me the current date and time, I only need the current date in a parsed date format. The time should be 00:00:00, the time that the day actually started and not my current time, is that possible? and if so, how would I accomplish that?
Operating system used: windows
Answers
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,074 Neuron
Have a look at the Date Functions, you can use datePart:
https://doc.dataiku.com/dss/12/formula/index.html#date-functions