Hello,
We’d like to pass date-type user properties but curious if we’d be able to properly filter on them in amplitude charts. They’ll be in the format YYYY-MM-DD.
Setting date-type user properties
Userlevel 7
+10
Hi
Yes, that date format should work. You should be able to apply filters and operators on that date type value.
Userlevel 3
+5
Hi Lance,
Saish is correct. Amplitude accepts date formats in ISO format, which includes the 'YYYY-MM-DD' format. This allows you to apply filters and operators on that date type value in your analysis.
For more complex operations, you might want to consider using the 'Number' type and store the date as a Unix timestamp. This will allow you to perform numerical operations on the date.
Also, if you're an enterprise customer or have purchased the Govern add-on, you can leverage the Derived Properties feature and use date time functions to format and create a derived property according to your use case.
For more information, you can refer to the following resources:
- Setting Date Values
- Derived Properties
I hope this helps! Let me know if you have any other questions.
Best Regards,
Jacenda
P.S. Checkout upcoming events and user meetups on our events page.
Saish is correct. Amplitude accepts date formats in ISO format, which includes the 'YYYY-MM-DD' format. This allows you to apply filters and operators on that date type value in your analysis.
For more complex operations, you might want to consider using the 'Number' type and store the date as a Unix timestamp. This will allow you to perform numerical operations on the date.
Also, if you're an enterprise customer or have purchased the Govern add-on, you can leverage the Derived Properties feature and use date time functions to format and create a derived property according to your use case.
For more information, you can refer to the following resources:
- Setting Date Values
- Derived Properties
I hope this helps! Let me know if you have any other questions.
Best Regards,
Jacenda
P.S. Checkout upcoming events and user meetups on our events page.
Reply
Welcome to the Amplitude Community!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. You can also create a Guest account below!
If you're a current customer, select the domain you use to sign in with Amplitude.
analytics.amplitude.com analytics.eu.amplitude.comor
Welcome to the Amplitude Community!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. Want to sign up as a guest? Create a Community account.
If you're a current customer, select the domain you use to sign in with Amplitude.
analytics.amplitude.com analytics.eu.amplitude.comor
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.