Forum Discussion

msalas's avatar
msalas
Regular Visitor
3 years ago
Solved

DateTime Format formula

Hello, Can someone help me with this formula? What I want done is that anything on my "Week No." column that has 1-4, in the new column "Months", it comes up as "Jan", 5-8 is "Feb", and so on. But I...
Need Help
Tutorial Requests
  • artemus's avatar
    artemus
    3 years ago

    I think the formula would be:

    Date.ToText(#date(2022, 1, 1) + [Week No.] * #duration(7, 0, 0, 0), [Format = "MMM", Culture = "en-us"])

     

serpiva64's avatar
serpiva64
Solution Sage
3 years ago

Hi,

i think you have to use " instead of '.