Skip to main content
Question

Formula Help

  • February 16, 2022
  • 0 replies
  • 19 views

Hello,

I have a question needing help with a formula. I have a field called "Start Date" and whatever date I put in that field I want it to auto-populate 3 other fields called "Week", "Month" and "Year". So if I put todays date in the "Start Date" field it would show 7 since its the 7th "Week" in the calendar year and would show 2 in the "Month" field (February is 2nd Month in the year) and show 2022 in the "Year" field. Any help to create this formula would be appreciated.

Thanks,
Derek

------------------------------
Derek Pipal
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
[Year]
numeric formula
Year([my date field])

[Month]
Numeric formula
Month([my date field])

[Week]
Numeric formula
WeekOfYear([my date field)]

https://login.quickbase.com/db/6ewwzuuj?a=dr&rid=204&rl=br9

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------