Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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.