I have a text field with values in the form 2009-W05-01 in them, i.e., a text version of HYYWD. Is there a way to bring that into an HYYWD format field?
I get blanks, so it apparently isn't happy receiving that format as an input.
HSETPT maybe? Has anyone stumbled across this before?This message has been edited. Last edited by: FP Mod Chuck,
May 17, 2018, 09:50 AM
John_Edwards
Alright, came up with this
The approach – 1. Make a date field, set to current date so you can see the parts change. 2. Set the year of the date field in The_Date_2. 3. Set the week of the date field in The_Date_3. 4. Set the weekday of the date field in The_Date_4. 5. Remove the hours, minutes and second in The_Date_5. 6. Print all of them to see each piece is functioning properly.