If you have a new question you’d like our support staff to post a response to, please visit our customer community, Data Security Insiders, to pose the question in our Discussion Boards. We have a thread “Ask Our Tech Experts” that our support team monitors on a regular basis, or you can start a new discussion where other GoAnywhere users and support staff can weigh in. Log in or create your new account at https://insiders.helpsystems.com/sign_in.
If you need an immediate response, please create a support ticket or contact our support team by email at [email protected].
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.