PDA

View Full Version : Calculate column



Wim Schimmel
4-May-2014, 06:14 AM
Is it possible to calculate a column with value of month of today getdate()

7668

Bo Andersen
5-May-2014, 06:49 AM
You should be able to sue something like

datename(month, getdate())

Best regards
Bo

Wim Schimmel
5-May-2014, 10:02 AM
Thank Bo,

7673

Bob Cergol
5-May-2014, 11:45 AM
Wim,

You should know that when dealing with a date column you don't need to make formulas for the sole purpose of extracting date parts or formatting. Dynamic AI will do that for you. In the "Available Fields" box in report design you'll notice it automatically shows year, quarter, and month parts for all date columns and you select those just like any other column for use in design.

But on the list options tab, the "Format" drop down you will see a long list of choices.
76747675

Also, know that for filter default values and for use as fixed condition on report, Dynamic AI provides a large number date functions. (See the revision/release docs mentioned in sticky post at top of this forum.) The function to filter by the month of today' date is: @mth()

Bob

Wim Schimmel
6-May-2014, 02:16 AM
Bob,

Thanks,

Is this information in the HELPFile ?

Bob Cergol
6-May-2014, 08:50 AM
Wim,

The on-line help file documents version 6.4. New functionality, enhancements, features and fixes were added in numerous builds following the release of 6.4 and that information is contained in several update documents. There is also a detailed revisions history document. (Current build as of this writing is 6.4.98)

Please review all of the links provided in this sticky post (http://support.dataaccess.com/Forums/showthread.php?49558-Dynamic-AI-Resources) at the top of this forum where you'll also find a link to documentation (ftp://ftp.dataaccess.com/pub/products/dynamicai/documentation). I suggest you download most of the files and read them. The titles will help you decide what is of interest.

Bob