Jump to content
One on One Extensive Advanced Excel Training ×
Business Intelligence & Analytics for Digital Transformation

Saurabh Jain

Administrators
  • Posts

    1,724
  • Joined

  • Last visited

  • Days Won

    61

Everything posted by Saurabh Jain

  1. Indicates whether the given datetime value occurs during the previous number of hours, as determined by the current date and time on the system.
  2. Indicates whether the given datetime value occurs during the previous minute, as determined by the current date and time on the system.
  3. Indicates whether the given datetime value occurs during the previous hour, as determined by the current date and time on the system.
  4. Indicates whether the given datetime value occurs during the next second, as determined by the current date and time on the system.
  5. Indicates whether the given datetime value occurs during the next number of seconds, as determined by the current date and time on the system.
  6. Indicates whether the given datetime value occurs during the next number of minutes, as determined by the current date and time on the system.
  7. Indicates whether the given datetime value occurs during the next number of hours, as determined by the current date and time on the system.
  8. Indicates whether the given datetime value occurs during the next minute, as determined by the current date and time on the system.
  9. Indicates whether the given datetime value occurs during the next hour, as determined by the current date and time on the system.
  10. Indicates whether the given datetime value occurs during the current second, as determined by the current date and time on the system.
  11. Indicates whether the given datetime value occurs during the current minute, as determined by the current date and time on the system.
  12. Indicates whether the given datetime value occurs during the current hour, as determined by the current date and time on the system.
  13. Creates a datetime from local and universal datetime formats.
  14. Returns a DateTime value from the supplied number.
  15. Returns a datetime value from a value.
  16. Returns a DateTime value set to the current date and time on the system.
  17. Returns a date part from a DateTime value
  18. Adds the timezonehours as an offset to the input datetime value and returns a new datetimezone value.
  19. Saurabh Jain

    #date

    Creates a date value from year, month, and day.
  20. Returns the year from a DateTime value.
  21. Returns a number for the count of week in the current year.
  22. Returns a number for the count of week in the current month.
  23. Returns a text value from a Date value.
  24. Returns a record containing parts of a Date value.
  25. Returns the start of the year.
×
×
  • Create New...