Unable to use datediff function in Apache OpenOffice Calc

openoffice-calc date
5,038

DATEDIFF seems to be OpenOffice Base/SQL function, not Calc function. It can be used in Calc as Basic macro custom function.

Share:
5,038

Related videos on Youtube

Peter Mortensen
Author by

Peter Mortensen

Updated on September 18, 2022

Comments

  • Peter Mortensen
    Peter Mortensen over 1 year

    I am unable to get a result by using the command =DATEDIFF('dd', '2007-08-01', '2007-09-01') in Apache OpenOffice Calc.

    Even using two columns of dates and using the formula =DATEDIFF('dd','A2','B2'), I am unable to find the difference between dates.

    How can I fix this?

  • PleaseStand
    PleaseStand almost 12 years
    I think there should be double quotes around the dates in your example.
  • cyberha4
    cyberha4 almost 12 years
    @PleaseStand: thank you for the hint, you were right.
  • fixer1234
    fixer1234 almost 8 years
    Can you expand your answer a little to explain how this works? Thanks.

Recents

Why Is PNG file with Drop Shadow in Flutter Web App Grainy?
How to troubleshoot crashes detected by Google Play Store for Flutter app
Cupertino DateTime picker interfering with scroll behaviour
Why does awk -F work for most letters, but not for the letter "t"?
Flutter change focus color and icon color but not works
How to print and connect to printer using flutter desktop via usb?
Critical issues have been reported with the following SDK versions: com.google.android.gms:play-services-safetynet:17.0.0
Flutter Dart - get localized country name from country code
navigatorState is null when using pushNamed Navigation onGenerateRoutes of GetMaterialPage
Android Sdk manager not found- Flutter doctor error
Flutter Laravel Push Notification without using any third party like(firebase,onesignal..etc)
How to change the color of ElevatedButton when entering text in TextField

Related

Get DayName from Date in OpenOffice Calc?
Open Office Calc: Convert a date to timestamp
How to add number of days to a date, consider only business days (i.e. ignore weekends)?
How to generate pseudo-random number in dart
How to create a timeline in flutter?
How to sort a List<String> of formatted dates in dart?
Changing The Text Color Of Cupertino Date Picker
Calculate difference between two sets of dates and divide the results in Flutter
How to check a date is expired or not in Flutter?
How to get a list of each week in a time range with Dart?