Sometimes working with old systems is a royal pain, where many dates are stored as 4 numeric fields (Century, Year, Month, Day) and in this case where one is stored as a 6 digit numeric field DDMMYY.
I need to select all records changed since a given date and have the compare date stored...
3 results in 0.0027 seconds.
-
Select Greater Than Date When Date Stored DDMMYY - Possible?
-
Sign on date VS system date
I am working on some production programming where a shift will spill over to the next day. I would like to capture the current (system) date and not the date the user signed on to the session.
Is the bif %date the way to go? What are the differences between UDATE DATE %DATE or any others... -
Check for blank dates
I am using
in my spec for dates. I call them true dates because we commonly use decimals for dates as well.Code:A S2CMDT L B 21 23DSPATR(CS) A DATFMT(*MDY)
I created a program to maintain...
