dateime on DevNet

DateTime query in where clause returns no results in pages data source

Eric Conklin — Sep 21, 2020 — Question

datasource dateime pages where clause

I am using the following where clause to query my pages from a blog via a pages data source web part:'{%EventDate %}' @ '{%GetDateTime(DateTime.Now)#%}' When this query runs in the pages data sou...

get current days week + next week

web dev — Feb 2, 2019 — Question

current week dateime next week week date

hello kentico dev i hope you re doing well i was trying to apply macro that show days of current week + next week is there custome methode thanks team

Kentico DateTime WebPart not working with Custom TimeZone

Vuthy Sok — Aug 10, 2018 — Question

dateime kentico kentico11 timezone

Hi guys,,I have setup kentico 11 I want to show time difference from my local time. I have used DateTime Webpart but time still get from my local time. My configure in WebPartDate and time format: ...

datetime ,date created

web dev — May 7, 2018 — Question

datecreated dateime

hello freinds any one have idea i try to apply a macro to show new created jobs my macro:{% if((DateTime.Now - DateCreated) @ 7){ %} NEW {% } #%}but its not working thanks

IS there a macro Method to Convert DateTime to SQl DateTime format?

benyamin jain — Sep 19, 2016 — Question

dateime macro macro expression

HiI want to use CurrentDateTime macro in SQl Query. But the returned date is not compatible with sql date string format.also how i can convert datetime using invariant culture in macro.say my date ...