WondersWhy
Technical User
Hi,
I need to know a SQL statement trick that would identify a record in a table with the value of a a calculation. Can this be done?
I have a calendar table that defines for a given date what accounting period the date falls under and whether it is a working day or not as well as give a unique working day number for each working day.
I would like to pull the "working_day_number" for a date, subtract a few days from that and with the result, point back to the table (an alias of course) and find out what the resulting date is.
Any ideas?
Thanks a bunch!
Tony T.
I need to know a SQL statement trick that would identify a record in a table with the value of a a calculation. Can this be done?
I have a calendar table that defines for a given date what accounting period the date falls under and whether it is a working day or not as well as give a unique working day number for each working day.
I would like to pull the "working_day_number" for a date, subtract a few days from that and with the result, point back to the table (an alias of course) and find out what the resulting date is.
Any ideas?
Thanks a bunch!
Tony T.