Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

CF_TIMECONV

The CF_TIMECONV function can be used to convert one time value to another time value.

Enter the formula =CF_TIMECONV("<time unit1>",<time value1>,<"time unit2">)

The following parameters need to be defined:

  • A time unit within quotation marks (e.g. "ISOWEEK").
  • An ISOWEEK time value that you want to convert or a cell reference to that time value.
  • The time value to which you want to convert within quotation marks (e.g. "ISODATE").

Example

=CF_TIMECONV("ISOWEEK",201115,"ISODATE") will return the value 20110411..20110417.

=CF_TIMECONV("ISODATE",20110404,"ISOWEEK") will return the value 201114.

This function can be very useful when importing actual values in the template. Most of the time, you might not have that data specified in the right time units in the database. For example, in your invoice stat view you have the data connected to an invoice date; however, in your template you want the actual values to be grouped per week. You can easily use this function to convert an ISOWEEK to an invoice date interval.

Note: The separator in the formula depends on the culture you are using in the application. "," for en-US, ";" for sv-SE, and so on.
Published:

CF_TIMECONV

The CF_TIMECONV function can be used to convert one time value to another time value.

Enter the formula =CF_TIMECONV("<time unit1>",<time value1>,<"time unit2">)

The following parameters need to be defined:

  • A time unit within quotation marks (e.g. "ISOWEEK").
  • An ISOWEEK time value that you want to convert or a cell reference to that time value.
  • The time value to which you want to convert within quotation marks (e.g. "ISODATE").

Example

=CF_TIMECONV("ISOWEEK",201115,"ISODATE") will return the value 20110411..20110417.

=CF_TIMECONV("ISODATE",20110404,"ISOWEEK") will return the value 201114.

This function can be very useful when importing actual values in the template. Most of the time, you might not have that data specified in the right time units in the database. For example, in your invoice stat view you have the data connected to an invoice date; however, in your template you want the actual values to be grouped per week. You can easily use this function to convert an ISOWEEK to an invoice date interval.

Note: The separator in the formula depends on the culture you are using in the application. "," for en-US, ";" for sv-SE, and so on.
For an optimal Community experience, Please view on Desktop
Powered by Zendesk