I think I have a similar issue; need to change the Timestamp format
The actual source like this SpecimenDate = 31-Jan-12
So i've convert using following function :
Code: Select all
if NullToEmpty(InfectCon_Patients.SPECIMEN_DATE) = "" then setnull() else if IsValid("date",InfectCon_Patients.SPECIMEN_DATE,"%dd-%mmm-%yy") then StringToTimestamp(InfectCon_Patients.SPECIMEN_DATE,"%dd-%mmm-%yy") else setnull()
on DS output : i'm getting like : 1912-01-31 00:00:00
and the Output on Table I'm getting like : mm/dd/yy 12:00AM
Don't know why
I like to see the output like YYYY-MM-DD 00:00:00
Thanks for your help!
F