datetime on DevNet

Wei Wang — Mar 16, 2021 — Question

calendar datetime

Hi,For a datetime field with Calendar control, can I default the time part to be 10am for any date user select?Thanks, Wei Wang

DateTime calculation and formatting

Wei Wang — Apr 10, 2020 — Question

datetime macro

Hi, Question again on datetime calculation and formatting. So I need to calculate two datetime fields using macro so I did {% expdate - CurrentDateTime #%} to get how many days until the password w...

Macro for Datetime calculation

Wei Wang — Apr 9, 2020 — Question

datetime macro

Hi,I need to write macro to calculate some datetime fields but I found this is strange. I can use AddDays function to the below CurrentUser.LastLogon field and this seems working correctly: {% Curr...

DateTime parsing issue

Gerard Young — Mar 25, 2020 — Question

datetime validation

Hi,I have a field in a web part with a Data type of @Date and time@The data resolves asGetValue(@Time@)| @3/25/2020 12:50:06 PM@ | object {string} When I try to parse the selected date in the web p...

GetDateTime(DateTime.Now) returns page publish time instead of current time

Mike Bilz — Jun 11, 2019 — Question

datetime macro macros

Hello Kentico Team,I am attempting to include the time a page was loaded within an editable text area on a page, however the macro appears to resolve to when the page was last saved, rather than to...

Where Condition for Date in Repeater

David Pearson — Aug 1, 2018 — Question

cmsrepeater datetime kentico 9

Trying to do a Where Clause in a Repeater. I tried: DocumentIsArchived = 0 @@ DocumentPublishTo @ getdate() with no luck in Kentico 9. Thanks David

BlogPostDate returns as False or Empty

Mike Bilz — Sep 26, 2017 — Question

blog post datetime ifempty workflow

Hello Kentico Team,I am attempting to add a @published on@ date to my blog post transformation, but for some reason all of my attempts have returned no results.@%# IfEmpty(Eval(@BlogPostDate@), @No...

SQL type 'datetime' is not registered

Alexander Staroselsky — Mar 14, 2017 — Question

datetime error forms sql

Hello,When trying to save a form with the Forms application, the following error is being generated when any of the fields have a @Date@ or @Date and time@ Data type.Where should this data type be ...

Date validation on a biz form

Deanna Martens — Feb 29, 2016 — Question

biz form datetime kentico 8 validation

Good morning,I have a date and time field on a biz form that I am trying to validate. I do not want the user to be able to select/enter a date and time that is in the future from when they are fil...

Is there a toString function in K#?

Yang Wen — Feb 11, 2016 — Question

datetime k# macro

This code works fine {% TrimStart(@2016@,2) %} for returning @16@However this doesn't work {% TrimStart(DateTime.CurrentDateTime.Year,2)%}Even though there is no mention in the document, I assume ...