Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 29, 2024 07:38 AM
Hi,
I cant for the life of me find a formula to
I have 3 date columns in each record, only one of these will be populated per record, i want to create an additional single column which would auto populate with the date from either of these 3 fields so i can format it to a week number (and YY of possible).
Is this possible to do and if so can anyone help with the formulae for this please?
Thank you so much, Sarah 🙂
1 Reply 1
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 29, 2024 11:38 PM
Try:
DATETIME_FORMAT(
{Date 1} & {Date 2} & {Date 3},
"WW YYYY"
)
