SOLVED
Changing my string text to a date format
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
alvingan43
5 - Atom
‎11-16-2023
12:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi!
How can i change my date to show the weekday of it
example, '1 July 2015' to 'Monday'
currently the text '1 july 2015' is a V_String data type
Thanks!!
Solved! Go to Solution.
Labels:
- Labels:
- Date Time
2 REPLIES 2
17 - Castor
‎11-16-2023
12:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @alvingan43 you are going to need to parse your date into a ISO format YYYY-MM-DD then format it into the date. You can do this in a formula tool using the Datetime parse and datetime format forumlas.
Datetimeformat(DateTimeParse([Date],"%d %B %Y"),"%A")
‎11-16-2023
09:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This helped a lot!! thanks!!
