Need to display current_date and time on Text Widget

Follow

Vinod Komarajapeta

January 23, 2020 05:57

I am using Text Widget in my dashboard to display the dashboard header content. In the same widget i want to display current date and time. The Date and Time stamp is location specific. If the dashboard is accessed by different user from different time zones, the current date and time should display as per user's time zone. Could any one help me how i can implement.

0

• 

  Nathan Giusti January 31, 2020 16:07

  You'll have to add a widget script to the text widget that pulls in the current date and time via javascript

   

  Something like

   

  var today = new Date(); var date = today.getFullYear()+'-'+(today.getMonth()+1)+'-'+today.getDate() + today.getHours() + ":" + today.getMinutes() + ":" + today.getSeconds();

  0

  Comment actions Permalink
• 

  Vinod Komarajapeta February 04, 2020 08:09

  Thanks Nathan.

  0

  Comment actions Permalink
• 

  Anu Marichamy November 18, 2020 17:52

  Hi

  i need to get the data of current week. can any one please help me to achieve this? i tried using the following query. but it is not working

  Select * From Acb Where WorkDate BETWEEN DATEADD(DAY, -7, GETDATE()) AND DATEADD(DAY, 1, GETDATE())

   

  Thanks,

  Anu

  0

  Comment actions Permalink

Please sign in to leave a comment.