Forum Discussion

Copper Contributor

May 29, 2025

add year month and week using just date field

I have this posting date field and I want to update yr mo and week based on posting date. I saw some suggestions online but cant make them work?

access

arnel_gp

Iron Contributor

Jun 03, 2025

as suggested, remove the YR, MO, Week field from your table and instead create a Query that will calculate those 3 fields:

SELECT [Internal Number], [Document Number], [Posting Date],
     Year([Posting Date]) As YR, 
    Month([Posting Date]) As MO, 
    DatePart("ww", [Posting Date]) As Week 
FROM [Sales by Customer-Item-Detail];