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

Saurabh Jain

Administrators
  • Posts

    1,725
  • Joined

  • Last visited

  • Days Won

    61

Everything posted by Saurabh Jain

  1. Returns the start of the year.
  2. Returns the start of the week.
  3. Returns the start of the quarter.
  4. Returns the start of the month.
  5. Returns the start of the day.
  6. Returns a number between 1 and 4 for the quarter of the year from a DateTime value.
  7. Returns the name of the month component.
  8. Returns the month from a DateTime value.
  9. Returns a logical value indicating whether the year portion of a DateTime value is a leap year.
  10. Returns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred in the period starting January 1st of the current year and ending on the current day, as determined by the current date and time on the system.
  11. Returns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the previous year, as determined by the current date and time on the system.
  12. Returns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the previous week, as determined by the current date and time on the system.
  13. Returns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the previous quarter, as determined by the current date and time on the system.
  14. Indicates whether the given datetime value dateTime occurs during the previous number of years, as determined by the current date and time on the system.
  15. Indicates whether the given datetime value dateTime occurs during the previous number of weeks, as determined by the current date and time on the system.
  16. Indicates whether the given datetime value dateTime occurs during the previous number of quarters, as determined by the current date and time on the system.
  17. Indicates whether the given datetime value dateTime occurs during the previous number of months, as determined by the current date and time on the system.
  18. Indicates whether the given datetime value dateTime occurs during the previous number of days, as determined by the current date and time on the system.
  19. Returns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the previous month, as determined by the current date and time on the system.
  20. Indicates whether the given datetime value dateTime occurs during the previous day, as determined by the current date and time on the system.
  21. Returns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the next year, as determined by the current date and time on the system.
  22. Returns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the next week, as determined by the current date and time on the system.
  23. Returns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the next quarter, as determined by the current date and time on the system.
  24. Indicates whether the given datetime value dateTime occurs during the next number of years, as determined by the current date and time on the system.
  25. Indicates whether the given datetime value dateTime occurs during the next number of weeks, as determined by the current date and time on the system.
×
×
  • Create New...