Convert to day of week using date field, like MOn, Tue , Wed
converting date formate -2007-01-01 00:00:00.000 to--- day of week
how to solve this problem in Parallal jobs.
Thank yo
Convert to day of week using date field, like MOn, Tue , Wed
Moderators: chulett, rschirm, roy
I jumped ahead of myself.
Change the default timestamp as I advised. Use the TimestampToString() function to change to string and then do
This will give you the day
Change the default timestamp as I advised. Use the TimestampToString() function to change to string and then do
Code: Select all
FIELD(date, "-", 2, 1)
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
WeekdayFromDate() will return the weekday number (based on your business rules for the start of the week). You first need to extract the date portion from the timestamp. Once you have the weekday number you can use Field() to perform a lookup from a string constant containing a delimited string of the weekday names.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.