Difference between revisions of "Manuals/calci/DATESTRING"

From ZCubes Wiki
Jump to navigation Jump to search
 
(2 intermediate revisions by one other user not shown)
Line 3: Line 3:
  
 
==Description==
 
==Description==
*This function  takes a date string and returns the date with month and day name.
+
*This function  takes a date string as input and returns the date with month and day name.
 
*In <math>DATESTRING(String)</math>,<math>String</math> is the any date value.  
 
*In <math>DATESTRING(String)</math>,<math>String</math> is the any date value.  
 
*This function is useful for setting date values based on string values.
 
*This function is useful for setting date values based on string values.
 
*For Example,DATESTRING("2/2/1982") returns Tue Feb 02 1982 00:00:00 GMT+0530 (India Standard Time).
 
*For Example,DATESTRING("2/2/1982") returns Tue Feb 02 1982 00:00:00 GMT+0530 (India Standard Time).
*Here It understands the continental Indian time zone abbreviations, but for general use, use a time zone offset.
+
*Here the function understands the continental Indian time zone abbreviations, but for general use, use a time zone offset.
*We can use Range values also. For Example: DATESTRING(#2/3/1998-4/7/1999).
+
*DD/MM/YYYY format can also used. For Example:"14/5/2005[DD/MM/YYYY]".
* #date notation needs mm/dd/yy format.
+
*Range values can also be used. For Example: DATESTRING(#2/3/1998-4/7/1999).
 +
* #date notation needs mm/dd/yy format.
  
 
==Examples==
 
==Examples==
Line 15: Line 16:
 
# DATESTRING("10/2/2019") = Wed Oct 02 2019 00:00:00 GMT+0530 (India Standard Time)
 
# DATESTRING("10/2/2019") = Wed Oct 02 2019 00:00:00 GMT+0530 (India Standard Time)
 
# DATESTRING("5/4/2100") = Tue May 04 2100 00:00:00 GMT+0530 (India Standard Time)
 
# DATESTRING("5/4/2100") = Tue May 04 2100 00:00:00 GMT+0530 (India Standard Time)
 +
# DATESTRING("20/6/2028[DD/MM/YYYY]") = Tue Jun 20 2028 00:00:00 GMT+0530 (India Standard Time)
 +
 +
==Related Videos==
 +
 +
{{#ev:youtube|v=24Z8TsyRVsY|280|center|Date String}}
  
 
==See Also==
 
==See Also==

Latest revision as of 06:46, 15 February 2019

DATESTRING (String)


  • is any date value.

Description

  • This function takes a date string as input and returns the date with month and day name.
  • In , is the any date value.
  • This function is useful for setting date values based on string values.
  • For Example,DATESTRING("2/2/1982") returns Tue Feb 02 1982 00:00:00 GMT+0530 (India Standard Time).
  • Here the function understands the continental Indian time zone abbreviations, but for general use, use a time zone offset.
  • DD/MM/YYYY format can also used. For Example:"14/5/2005[DD/MM/YYYY]".
  • Range values can also be used. For Example: DATESTRING(#2/3/1998-4/7/1999).
  • #date notation needs mm/dd/yy format.

Examples

  1. DATESTRING("2/3/1998") = Tue Feb 03 1998 00:00:00 GMT+0530 (India Standard Time)
  2. DATESTRING("10/2/2019") = Wed Oct 02 2019 00:00:00 GMT+0530 (India Standard Time)
  3. DATESTRING("5/4/2100") = Tue May 04 2100 00:00:00 GMT+0530 (India Standard Time)
  4. DATESTRING("20/6/2028[DD/MM/YYYY]") = Tue Jun 20 2028 00:00:00 GMT+0530 (India Standard Time)

Related Videos

Date String

See Also

References