Visokio website     Downloads     Video tutorials     KnowledgeBase  
Date/Time: DateToText Function, using "yyyy" and not "YYYY" - Visokio Forums
Date/Time: DateToText Function, using "yyyy" and not "YYYY"
  •        benjamin March 25, 2015 2:08PM
    Hi,
    Using the DatetoText function results in errors when you use dates near the end of the year (anywhere from the the 29th-31st of Dec)
    Example :
    DATETOTEXT(date(2013,12,31),"YYYY")

    Thanks, Ben
  • 1 Comment
  •     paola March 25, 2015 2:25PM
    Please replace "YYYY" with "yyyy" in the syntax. You can find the date formats page in our KnowledgeBase:
    YYYY format - Week year: As per yyyy, except this is the "week year", i.e. the year of the current week-in-year, which is not always the same for a few days in the first and last weeks of the year.
    http://www.visokio.com/dates-and-times

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership