Date getting null values on StrpTime?

[iupreti]

Screenshot 2022-12-05 at 6.45.50 AM.png
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?

[yuanliu · Accepted solution]

The date format appears to be "%d/%m/%Y", not "%m/%d/%Y".

[iupreti]

Screenshot 2022-12-05 at 7.47.40 AM.png
Tried that as well but no luck

[SanjayReddy]

Hi @iupreti

you need to remove quotes for opened_at inside strptime function.

can you try runing removing quotes,

It should work

[iupreti]

@SanjayReddyThank you it worked.