Day from a date

sanjayS · Post by **sanjayS** » Thu May 26, 2011 11:59 pm

Hi all,

Could you please let me know hoe to get a Day (Monday,Tuesday) from a date ...Is there any functions in Parallel transformer..I have tried ..but am unable to figure out..

Thanks,
Sai

ray.wurlod · Post by **ray.wurlod** » Fri May 27, 2011 12:25 am

Not sure whether this is a parallel job or a server job. You marked it as a parallel job but posted it in the server job forum.

Server Job Answer

Oconv(InLink.TheDate, "DWA") for week day name, Oconv(InLink.TheDate, "DWB") for week day name abbreviation.

Parallel Job Answers

WeekdayFromDate() will give you a weekday number in the week. Use the Field() function to extract the appropriate element from a delimited string of week day names.

Or use DateToString() function with an appropriate format string to return a week day name or a week day name abbreviation.

All of this is in the manual (Parallel Job Developer's Guide) and on-line help.

peddakkagari · Post by **peddakkagari** » Fri May 27, 2011 12:41 am

Using WeekdayFromDate function you can get the day in numbers(0 to 6)

sanjayS · Post by **sanjayS** » Fri May 27, 2011 3:23 am

Thanks for help..

problem resolved...