The extract date is wrong

[lhlong]

Hi experts,

I set up a value of the text is “Current date/time:extract day” as the information in the attached picture, the Current date/time is Oct 03, 2021, 00:47:11, so it should be returned 3, but it shows 0, please tell me how to correct it

Note: it happens at 00h, other hours it shows correctly

[mikeloc]

Hi there, @lhlong… if I understand your post correctly, I believe you want to extract date instead of day.

https://manual.bubble.io/core-resources/data/operations-and-comparisons#extract-from-date

Give that a shot and see if you get the desired result.

Best…
Mike

[lhlong]

You are correct, thanks Mikeloc for your support!

Regards,
Long