Manuals/calci/DATESTRING

DATESTRING (String)

• $String$ is any date value.

Description

• This function takes a date string and returns the date with month and day name.
• In $DATESTRING(String)$,$String$ 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.
• We can use the DD/MM/YYYY format also. For Example:"14/5/2005[DD/MM/YYYY]".
• We can use Range values also. 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

• DATE
• DATEVALUE
• DAY

References

• Date Serial

• List of Main Z Functions

• Z3 home