Variables List

Top  Previous  Next

InFocus supports custom variables for use in advanced query applets like SQL Query, Custom Reports and Dashboard Queries Manager. Variables are referenced in queries using the following syntax @variable@

 

 

Variable Type

Description

Example

Accounting






@CURRENTPERIODCODE@

Current Period Code

2019-12

@CURRENTPERIODEND@

Current Period End Date

2019/12/31

@CURRENTPERIODMONTH@

Current Period Month

12

@CURRENTPERIODSTART@

Current Period Start Date

2019/12/01

@CURRENTPERIODYEAR@

Current Period Year

2019

@INVOICEPERIODCODE@

Invoicing Period Code

2019-12

@INVOICEPERIODEND@

Invoicing Period End Date

2019/12/31

@INVOICEPERIODMONTH@

Invoicing Period Month

12

@INVOICEPERIODSTART@

Invoicing Period Start Date

2019/12/01

@INVOICEPERIODYEAR@

Invoicing Period Year

2019

@LASTPERIODCODE@

Last Period Code

2019-11

@LASTPERIODEND@

Last Period End Date

2019/11/30

@LASTPERIODMONTH@

Last Period Month

11

@LASTPERIODSTART@

Last Period Start Date

2019/11/01

@LASTPERIODYEAR@

Last Period Year

2019




Company






@COMPANYNAME@

Company Name

Pulls the Company Name from Global Settings> General Tab> Company Name & Log-in Type section> Name




Date/Time






@AMPM@

AM or PM

PM

@DAY@

Current Day of the Month

27

@DAY2@

Current Day of the Month (Padded)

27

@HOUR@

Current Hour

6

@HOUR2@

Current Hour (Two Digits)

06

@LASTMONTHEND@

End of the Month

2019/11/30

@LASTMONTHSTART@

Start of the Month

2019/11/01

@MINUTE@

Current Minute

33

@MINUTE2@

Current Minute (Two Digits)

33

@MONTH@

Current Month Number

12

@MONTH2@

Current Month Number (Padded)

12

@MONTHEND@

End of the Month

2019/12/31

@MONTHSTART@

Start of the Month

2019/12/1

@NEXTMONTHEND@

End of the Month

2020/01/31

@NEXTMONTHSTART@

Start of the Month

2020/01/01

@NOW@

Current Date and Time on the Server

Dec 27 2019  6:33PM

@SECOND@

Current Second

3

@SECOND2@

Current Second (Two Digits)

03

@TIME@

Current Time

6:33 PM

@YEAR@

Current Year

2019

@YEAR2@

Current Year (Two Digits)

19

@YEAREND@

End of the Year

2019/12/31

@YEARSTART@

First of the Year

2019/1/1




Global Variables






@EBBT@



@EBITDA@



@EmptyName@


-- Unspecified --

@ProjectAddressName@


Project Location




User






@MYCODE@

Logged in user's Employee Code


@MYEMPID@

Logged in user's Employee ID


@MYID@

Logged in user's Employee ID


@MYUSERID@

Logged in user's User ID


@MYUSERNAME@

Logged in user's Username