Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
EMaebe
Contributor III
Contributor III

Yesterday date & static time formula

I need a formula that gives me the yesterday (weekdays only not weekends) and a timestamp for 03:00:00 PM or 15:00:00 as 24 hour clock is fine.

 

I have =Date(FirstWorkDate(today(),2)+15/24,'YYYY-MM-DD HH:MM:SS'), but it's adding 15 to the hours and the minutes are showing 12 for some reason.  Currently, that formula is returning 2022-12-07 15:12:00, but I need it to return 2022-12-07 15:00:00.  


Can anyone point me in the right direction? Thanks! 

Labels (1)
1 Solution

Accepted Solutions
MarcoWedel

=Date(FirstWorkDate(today(),2)+15/24,'YYYY-MM-DD hh:mm:ss')

MM in capital letters means month rather than minutes.

 

View solution in original post

2 Replies
MarcoWedel

=Date(FirstWorkDate(today(),2)+15/24,'YYYY-MM-DD hh:mm:ss')

MM in capital letters means month rather than minutes.

 

EMaebe
Contributor III
Contributor III
Author

Thank you so much! That worked. I'm so glad it was such a simple fix.