Extract Year on the 1st of January

Need help
1

Hi there

I have got a database where I have a field date (as date) and the year as number.

The fields with the dates are already prefilled with the specific dates.

I just created a workflow which extracts the year from the date-field and stores the year as a number into this field. I use this for the dropdown in order to group the dates.

Now it worked actually but on the 1st January of the year, the extracted year it the previous one. Can anybody tell my why?

See the date in the middle of the three records
image

And this is my workflow

image
image437×494 23.1 KB

Thank you for your support

2

Use Rounded down to a year instead of extract year

3

Hi @amit.chauhan Extract means just the year and rounded down will give me the whole datetime, isn’t it?

4

TestDateYear
TestDateYear1063×835 62.6 KB

Use date formatting, this way you can save as text and also integer. It will work on Time zone selection too as it will consider User’s current time zone.

5

It’s probably a timezone issue…

What timezone are you using for the Extract Year expression?

6

I use the current timezone (I am based in Switzerland (GMT+2)

Monday, 31st March 2025, 13:23)

image
image700×298 24.8 KB

7

And is that the correct timezone to use?

8

Yes. The time and date would be right. And because I grap a datetime in the past (1st of Jan 2025) it is weird that I get 2024 as year.

9

It seems like an timezone issue but I do not get why when in the database stays 1/1/25 12 am and then the converted/extracted version minus 1 hour
image

Also see the different timestamps although it is always 12 am I get different hours on the converted column

image
image798×665 29.6 KB
@emmanuel

10

I found a solution

When I do a bulk in the database. It looks like I have described it above. When I trigger a schedule API Workflow on a list and then do the same, it works.

1 Like
11

This topic was automatically closed after 70 days. New replies are no longer allowed.