Date extract
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Saifshaikh026
6 - Meteoroid
‎03-21-2024
02:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
day month
25 feb/march
26 feb/march
27 feb/march
28 feb/march
29 feb/march
1 feb/march
2 feb/march
3 feb/march
required output
date
25 feb
26 feb
27 feb
28 feb
29 feb
1 march
2 march
3 march
Can anyone help me with this please
Labels:
- Labels:
- Date Time
2 REPLIES 2
binuacs
21 - Polaris
‎03-21-2024
02:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Saifshaikh026 What is the logic applied to get the desired result?
suraj46nair
6 - Meteoroid
‎03-21-2024
03:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
use formula tool -
IF [Day]<25 THEN 'march'
ELSEIF [Day]>=25 THEN 'feb' ELSE '' ENDIF
