Parsing Date to query in Audit Log and Audit Properties Table : Bienabee

How can we help you today?

Parsing Date to query in Audit Log and Audit Properties Table Print

Modified on: Sat, 23 Apr, 2016 at 7:08 PM

Applies To:

VBS, OTA, Workflow

Issue:

The date format in the database table is yyyy-mm-dd. I need to format the date 4/7/2015 to this format and include 0's on the two digit dates.

Solution:

dStartDate = CDate("4/7/2014")

strParcedStartDate = DatePart("yyyy", dStartDate) & "-" & _ 
Right("0" & DatePart("m", dStartDate), 2) & _ 
"-" & Right("0" & DatePart("d", dStartDate), 2)

This gives you a string to work with in the correct format to query the Audit Properties table.

Did you find it helpful? Yes No

Help Desk Software by Freshdesk

How can we help you today?

Parsing Date to query in Audit Log and Audit Properties Table Print

Related Articles