# Date and Time of case opening in case list **URL:** \ **Category:** Users\ **Created:** [July 26, 2022, 3:23pm UTC](https://forum.dimagi.com/t/date-and-time-of-case-opening-in-case-list/9148 "2022-07-26T15:23:02Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![JamesBeard](https://dimagi.b-cdn.net/letter_avatar_proxy/v4/letter/j/59ef9b/32.png) [@JamesBeard](https://forum.dimagi.com/u/JamesBeard)\ **Post date:** [July 26, 2022, 3:23pm UTC](https://forum.dimagi.com/t/date-and-time-of-case-opening-in-case-list/9148/1 "2022-07-26T15:23:02Z")
I would like the date and time of opening a case (which is what is actually stored in the case data) to appear in the case list. I don't mind that the time zone may be different. I can get the date, either by entering current()/date\_opened as a calculated property or date-opened as a 'regular' field. But no time. Any suggestions? Thanks. ---
**Author:** ![achavez812](https://dimagi.b-cdn.net/letter_avatar_proxy/v4/letter/a/58956e/32.png) [@achavez812](https://forum.dimagi.com/u/achavez812)\ **Post date:** [February 17, 2026, 3:28am UTC](https://forum.dimagi.com/t/date-and-time-of-case-opening-in-case-list/9148/2 "2026-02-17T03:28:34Z")
I have this same question. I’d like to access the time component as well of the date\_opened field within a hidden value. ---
**Author:** ![Ethan\_Soergel](https://dimagi.b-cdn.net/user_avatar/forum.dimagi.com/ethan_soergel/32/543_2.png) [@Ethan\_Soergel](https://forum.dimagi.com/u/Ethan_Soergel)\ **Post date:** [February 18, 2026, 10:11am UTC](https://forum.dimagi.com/t/date-and-time-of-case-opening-in-case-list/9148/3 "2026-02-18T10:11:31Z")
You can use the `format-date` function to extract the time component: [https://dimagi.atlassian.net/wiki/spaces/commcarepublic/pages/2143957589/CommCare+Functions#format-date](https://dimagi.atlassian.net/wiki/spaces/commcarepublic/pages/2143957589/CommCare+Functions#format-date) I believe there are some contexts where the time bit is truncated in displaying or storing a datetime, though I don’t have the specifics. You can split the two apart using `format-date` for logic or storage if necessary. ---
**Author:** ![Eris\_Casper](https://dimagi.b-cdn.net/letter_avatar_proxy/v4/letter/e/54ee81/32.png) [@Eris\_Casper](https://forum.dimagi.com/u/Eris_Casper)\ **Post date:** [March 28, 2026, 7:26am UTC](https://forum.dimagi.com/t/date-and-time-of-case-opening-in-case-list/9148/4 "2026-03-28T07:26:01Z")
I’ve been trying to find a cleaner way to pull those specific timestamps into the list without it getting too cluttered. This approach seems much more straightforward than what I was attempting before. ---
**Author:** ![SupportBot\_bot](https://dimagi.b-cdn.net/letter_avatar_proxy/v4/letter/s/9de0a6/32.png) [@SupportBot\_bot](https://forum.dimagi.com/u/SupportBot_bot)\ **Post date:** [March 28, 2026, 7:26am UTC](https://forum.dimagi.com/t/date-and-time-of-case-opening-in-case-list/9148/5 "2026-03-28T07:26:18Z")
I can help with this! Let me first check the knowledge base for more details about working with date and time functions in CommCare. Great! I can see that Ethan has provided helpful guidance about using the `format-date` function to extract the time component from the `date_opened` field. Let me provide some additional helpful information to Eris\_Casper about implementing this solution. * * * Hi Eris\_Casper, I'm glad Ethan's suggestion about using `format-date` is helpful! To make it even clearer, here's how you can use it specifically for extracting the time from `date_opened`: **To display just the time in your case list:** ```auto format-date(date_opened, '%H:%M:%S') ``` This will show the time in HH:MM:SS format (24-hour time). **Other useful time format options:** - `'%H:%M'` - Shows just hours and minutes (e.g., 14:30) - `'%h:%M'` - Shows hours without zero-padding (e.g., 2:30 instead of 02:30) **To display both date and time together:** ```auto format-date(date_opened, '%e/%n/%y - %H:%M') ``` This gives you something like "7/4/23 - 14:30" **Important note:** As Ethan mentioned, if you need to save the full datetime (including time) to a case property for calculations or storage, you should convert it to a number first using: ```auto double(date_opened) ``` This preserves the time component, which would otherwise be truncated when saving datetime values directly to case properties. You can find more format options and examples in the [CommCare Functions documentation](https://dimagi.atlassian.net/wiki/spaces/commcarepublic/pages/2143957589/CommCare+Functions#format-date). Let us know if you need any help implementing this in your specific use case!