Manuals/calci/DATESTRING

Revision as of 15:38, 15 August 2017 by Devika (talk | contribs) (Created page with "<div style="font-size:30px">'''DATESTRING (String)'''</div><br/> *<math>String</math> is any date value. ==Description== *This function takes a date string and returns the d...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
DATESTRING (String)


  • is any date value.

Description

  • This function takes a date string 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 It understands the continental Indian time zone abbreviations, but for general use, use a time zone offset.

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)

See Also

References