I need to retrieve the day of the week (1 through 7) from the current date to use as a file extension. Using the date format of 'F' in a timestamp expression today (Wednesday) is always returning a value of '2' instead of '4'. What am I missing in this? My code is:
<timestamp version="1.0" disabled="false">
<format outputVariable="DW_DAY" pattern="F" />
Maybe I'm misunderstanding the purpose of this value - I think it is telling me the number of occurrences of the day of the week within that month? So it is telling me that it is the second Wednesday of the month?
If so, is there a function that will tell me what day of the week it is, like '1' is Sunday, '2' is Monday, '5' is Thursday, etc? Or do I need a table that produces that?
Thanks Rick, I guess it will have to work. I can make an xref table based on the day name to get the number. The user may want to have Monday = Day 1, so an xref would work better anyway in that situation.