https://community.splunk.com/t5/Splunk-Search/Date-getting-null-values-on-StrpTime/m-p/623156#M216638 <P>The date format appears to be "%d/%m/%Y", not "%m/%d/%Y".</P> Mon, 05 Dec 2022 01:53:16 GMT yuanliu 2022-12-05T01:53:16Z https://community.splunk.com/t5/Splunk-Search/Date-getting-null-values-on-StrpTime/m-p/623155#M216637 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2022-12-05 at 6.45.50 AM.png" style="width: 999px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/22839i5462522D11E72446/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot 2022-12-05 at 6.45.50 AM.png" alt="Screenshot 2022-12-05 at 6.45.50 AM.png" /></span><BR />I've field name opened_at with the date value shown in the image. But, while taking value from it, it returns a null value. Am I missing something here?</P> Mon, 05 Dec 2022 12:49:17 GMT https://community.splunk.com/t5/Splunk-Search/Date-getting-null-values-on-StrpTime/m-p/623155#M216637 iupreti 2022-12-05T12:49:17Z https://community.splunk.com/t5/Splunk-Search/Date-getting-null-values-on-StrpTime/m-p/623156#M216638 <P>The date format appears to be "%d/%m/%Y", not "%m/%d/%Y".</P> Mon, 05 Dec 2022 01:53:16 GMT https://community.splunk.com/t5/Splunk-Search/Date-getting-null-values-on-StrpTime/m-p/623156#M216638 yuanliu 2022-12-05T01:53:16Z https://community.splunk.com/t5/Splunk-Search/Date-getting-null-values-on-StrpTime/m-p/623159#M216639 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2022-12-05 at 7.47.40 AM.png" style="width: 999px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/22842i9DFF15988CDB6E6B/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot 2022-12-05 at 7.47.40 AM.png" alt="Screenshot 2022-12-05 at 7.47.40 AM.png" /></span><BR />Tried that as well but no luck</P> Mon, 05 Dec 2022 02:04:21 GMT https://community.splunk.com/t5/Splunk-Search/Date-getting-null-values-on-StrpTime/m-p/623159#M216639 iupreti 2022-12-05T02:04:21Z https://community.splunk.com/t5/Splunk-Search/Date-getting-null-values-on-StrpTime/m-p/623172#M216641 <P>Hi <a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/251885">@iupreti</a><BR /><BR />you need to remove quotes for opened_at inside strptime function.<BR /><BR />can you try runing removing quotes,<BR /><BR />It should work</P> Mon, 05 Dec 2022 05:11:07 GMT https://community.splunk.com/t5/Splunk-Search/Date-getting-null-values-on-StrpTime/m-p/623172#M216641 SanjayReddy 2022-12-05T05:11:07Z https://community.splunk.com/t5/Splunk-Search/Date-getting-null-values-on-StrpTime/m-p/623187#M216644 <P><a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/236694">@SanjayReddy</a>Thank you it worked.</P> Mon, 05 Dec 2022 07:20:29 GMT https://community.splunk.com/t5/Splunk-Search/Date-getting-null-values-on-StrpTime/m-p/623187#M216644 iupreti 2022-12-05T07:20:29Z