#date functions

DATEVALUE Function | How to use DATEVALUE Function in Excel

Excel में DATEVALUE Function एक pre – defined Function है जिसे Date & Time function की category में रखा गया है। Excel DATEVALUE Function किसी Date को ,जो कि Excel Sheet में टेक्स्ट के फॉर्मेट में स्टोर है ,उसे एक Excel डेट में Change कर देती है। इस Date को यह एक सीरियल नंबर के रूप में Display करता है। Syntax:- =DATEVALUE(date_text) Arguments:- Date_text:- वह डेट जिसे Value में Change करना है ,जो…

How Do You Calculate the End of the Month in SQL?

When working with SQL dates, sometimes you need to calculate the end of the month.  Months are tricky!  Some are 28 days, others 30 or 31, and now and then there’s a leap year!

So, given a date, how do you calculate the number of days remaining in the month?

The calculation is really a two-step process:

Determine the last date of the month.

Calculate the difference in days, between the date in…

SAS : Post 36 : Introduction to Date Functions

A date value is actually a numeric value but it is treated differently. You can perform approximately all numeric operations on a date value.

MDY Function: Creating date values from normal numeric values

TODAY Function: Get the current date

This function gives you the date as per your system. So you can say that it is a dynamic function whose value depends upon on which date the code is being…