Strftime() %b format returns '000'

🧩 Low-Code Development
#1

I’m trying to get the 3-letter abbreviation for the month using the %b formatting argument for strftime(), but I get three zeroes as the return. Is there an issue here?

#2

Can you post the full expression you are using?

#3

strftime(dateField, “%d %b %Y”)

I’m aiming for something like “24 Mar 2024”. What I get is “24 000 2024”.

#4

I think this might be a bug. %B returns Month successfully, but %b returns 000. Maybe run with %B or %m as a workaround?

1 Like
#5

What database are you using?
Is this on workflows?

#6

We use a Postgres DB. I used @colby.ritter expression in a workflow, setting a value in a txt field

1 Like
#7

Interesting… %b should do what you wanted it to be so it looks like an easter egg…
Refer to here

#8

I’m using postgresql as well, and yes, this is happening in workflows.

1 Like
#9

use the workaround @mark suggested for now

#10

I used this:

strftime(dateField, “%d”) + " " + substring(strftime(dateField, “%B”), 0, 2) + " " + strftime(dateField, “%Y”)

1 Like