An emotional and depressed Adrian refuses to leave the house or allow visitors, leaving friends and family uncertain how to help her grieve.
Ricky finds out from Ben that Amy told Adrian that they move in together mean while Ben starts telling people that he wants out of the marriage and starts bad mouthing Ricky's and Amy's relationship.
The syntax for the HDATE function is as follows: Compute Var/format = HDATE(infield, outfield); Using my example from before we would have: MAINTAIN Compute DT1/HYYMDm = HGETC(26, DT1); Compute DT2/YYMD = HDATE(DT1, DT2); Type “DT1 = END And that yields the following: DT1 = 2007/03/02 .063000 DT2 = 2007/03/02 While you cannot compute a date-time field to a standard date, the opposite is allowed.
If you have a standard date, you can equate it to a date-time field. Maintain can take advantage of all of the date-time routines available to reporting.
The syntax of this routine is as follows: Compute Var/format = HGETC(length, outfield); The format must be a valid date-time format and the outfield must be the name of the variable. A simple example is like this: MAINTAIN Compute DT1/HYYMDm = HGETC(26, DT1); Type “DT1 = END This yields the following: DT1 = 2007/03/02 .063000 If you try to compute a date-time field to a standard date field, you get an error. When doing most calculations, Maintain handles the transformation for you. You can compute an integer to an alpha or a decimal to a float without any issues.
However, if you want to extract just the date from a date-time expression, use the HDATE function.